场景
需求
查每个人的Orderstr 是1 的数据,并保证name不重复
oracle
select *
from (SELECT a.*, row_number() over(partition by ida order by orderstr) rn
FROM (select orderstr, name, ida from test) a )
where rn = 1 ;
结果
mysql
按 员工号STAFF_ID 分组 按 时间START_TIME 排序 取每个员工最新数据
select SUBSTRING_INDEX(group_concat(STAFF_ID order by START_TIME asc),',',1) as STAFF_ID,START_TIME
from t_acc_user_accommodation a GROUP BY STAFF_ID;