34,590
社区成员
发帖
与我相关
我的任务
分享
select * from(select px=row_number()over(partition by VID ,VName order by TID,* from tb)t where px<>1
union all
select * from(select px=row_number()over(partition by VID ,VName order by TID desc),* from tb)t where px<>1
SELECT *
FROM TB t
WHERE EXISTS
( SELECT 1 FROM TB WHERE T.TID>MIN(TID) AND T.TID<MAX(T.TID) AND Vid = t.VID AND [VName] = t.[VName] GROUP BY VNAME,VID)
SELECT *
FROM TB t
WHERE TID != ( SELECT MIN(Tid)
FROM TB
WHERE Vid = t.VID
AND [VName] = t.[VName]
)
AND Tid != ( SELECT MAX(Tid)
FROM TB
WHERE Vid = t.VID
AND [VName] = t.[VName]
)
SELECT *
FROM TB T1
WHERE EXISTS(
SELECT 1 FROM TB T2 WHERE T2.VID=T1.VID AND T2.VNAME=T1.VNAME AND T2.TID<T1.TID
) AND EXISTS(
SELECT 1 FROM TB T2 WHERE T2.VID=T1.VID AND T2.VNAME=T1.VNAME AND T2.TID>T1.TID
)