34,590
社区成员
发帖
与我相关
我的任务
分享
select 员工姓名 ,打卡日期=max(打卡日期)
from tb
group by 员工姓名
select
*
from
tb t
where
processtime=(select max(processtime) from tb where employee=t.employee)
select *
from tb a
where not exists (select 1
from tb b
where b.employee=a.employee
and b.processtime> a.processtime)