34,590
社区成员
发帖
与我相关
我的任务
分享
select * from tab t
where username='张三' and exists(select
* from tab tb where teamid=t.teamID and username='王五' and (abs(sort-t.sort)=1 or
(t.Sort-case when tb.Sort=(select MAX(sort) from tab where TeamId=tb.TeamId) then 0 else tb.Sort end)=1 or
(tb.Sort-case when t.Sort=(select MAX(sort) from tab where TeamId=t.TeamId) then 0 else t.Sort end)=1
))
SELECT TOP 1 userid
FROM (
SELECT t.userid,
t_next.username as nextuser,
t_first.username as firstuser
FROM tab t
LEFT JOIN tab t_next
ON t_next.teamid=t.teamid
AND t_next.sort=t.sort+1
LEFT JOIN tab t_first
ON t_first.teamid=t.teamid
AND t_first.sort=1
WHERE t.username = '张三'
) T
WHERE nextuser = '周六'
OR ( nextuser IS NULL
AND firstuser = '周六'
)
select userid from tab t
where username='张三' and exists(select
* from tab where teamid=t.teamID and username='周六' and sort<>t.sort)