28,390
社区成员
发帖
与我相关
我的任务
分享
SELECT a.usid, a.corpname, a.job FROM hr_positions a WHERE a.id IN
(SELECT TOP 1 p.id FROM hr_positions p WHERE p.status = 0 AND p.istop=0 AND p.istag=0 AND a.usid=p.usid ORDER BY ISNULL(p.modifydate, p.entrydate) DESC)
SELECT p.usid,p.corpname,p.job FROM hr_positions p WHERE p.status = 0 AND p.istop=0 AND p.istag=0 ORDER BY ISNULL(p.modifydate, p.entrydate) DESC