34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM [ListWorkerDetails06] WHERE (work_date >= '2011-06-23 00:00:00') AND (work_date <= '2011-06-24 00:00:00') AND workerID='00152'
select top 1 * from [ListWorkerDetails06] order by work_date desc
select
count(1)
from
tb t
where
workerID<>'00152'
and
work_date =(select max(work_date ) from tb where workerID=t.workerID)