select *from clock,(select min(rectime) as time1,workid as id from clock group by workid) t where t.id=clock.workid
这样写是根据工号分组取最小值,我想在这前提下再根据日期取最小值要怎么弄啊
...全文
2484打赏收藏
大佬还在吗,还有SQL问题
select *from clock,(select min(rectime) as time1,workid as id from clock group by workid) t where t.id=clock.workid 这样写是根据工号分组取最小值,我想在这前提下再根据日期取最小值要怎么弄啊
时间,我想按工号日期分组取最小的值[/quote]
那你在group by workid后面加上日期不就行了吗[/quote]
时间,我想按工号日期分组取最小的值[/quote]
那你在group by workid后面加上日期不就行了吗[/quote]
汗,一开始就试过了,执行时间好久不过已经OK了,谢谢