根据 员工的SupplierEmployeeId以及任务TaskId 两个条件进行分组查询最后一条记录可以这样实现
select * from M_SignRecord where Sr_Id IN (select MAX(Sr_Id) from M_SignRecord group by Sr_SupplierEmployeeId,Sr_TaskId)
select * from M_SignRecord where Sr_Id IN (select MAX(Sr_Id) from M_SignRecord group by Sr_SupplierEmployeeId,Sr_TaskId)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29395669/viewspace-1064432/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29395669/viewspace-1064432/