34,571
社区成员
发帖
与我相关
我的任务
分享
select * from (
select *,row_number(partition by Staff_name ,CCC,CCC_date order by id) as rn from position
) t where t.rn=1
如果没有别的字段,可以用group by 或者 distinct都可以
用distinct只返回四个字段,用group by可以重复数据中最大或最小的ID也拿出
select distinct Staff_name ,CCC,CCC_date from position
select * from (
select *,row_number(partition by CCC,CCC_date order by id) as rn from position
) t where t.rn=1
SELECT MIN(id), Staff_name, CCC, CCC_date
FROM position
GROUP BY Staff_name, CCC, CCC_date