DECLARE @TBL TABLE ( A INT, B INT )
INSERT INTO @TBL
( A, B )
VALUES ( 1, -- A - int
2 -- B - int
)
INSERT INTO @TBL
( A, B )
VALUES ( 1, -- A - int
3 -- B - int
)
INSERT INTO @TBL
( A, B )
VALUES ( 1, -- A - int
4 -- B - int
)
SELECT [@TBL].*
FROM @TBL
INNER JOIN ( SELECT ROW_NUMBER() OVER ( PARTITION BY A ORDER BY A ) num ,
A ,
B
FROM @TBL ) b
ON b.A = [@TBL].A
AND b.num = 2
SELECT ROW_NUMBER() OVER ( PARTITION BY A ORDER BY A ) num ,
A ,
B
FROM @TBL
SELECT ROW_NUMBER() OVER ( ORDER BY A ) num ,
A ,
B
FROM @TBL
常用SQL整理 - ROW_NUMBER()
最新推荐文章于 2022-11-22 18:17:27 发布