34,590
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([spid] int,[spuserid] int,[spcixu] int,[spjeguo]INT ,[SQID] int)
Insert #T
select 1,5,1,null,5 union all
select 2,8,2,null,5 union all
select 3,10,3,null,5
Go
--测试数据结束
SELECT *
FROM #T a
WHERE NOT EXISTS ( SELECT *
FROM #T b
WHERE a.SQID = b.SQID
AND a.spcixu > b.spcixu
AND b.spjeguo IS NULL )
AND a.spuserid=8 --这里是查询id