有一个子查询以返回每个技术人员的最大AllocationTime。加入该结果:
select t1.*
from tbservicecallallocation t1
join (select TechnicianIDF, max(AllocationTime) as MAxAllocationTime
from tbservicecallallocation
group by TechnicianIDF) t2
on t1.TechnicianIDF = t2.TechnicianIDF
and t1.AllocationTime = t2.MAxAllocationTime
(可选)ORDER BY
在末尾添加子句:
ORDER BY AllocationStatus DESC
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句