DECLARE @TB TABLE( ID INT) INSERT @TB SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 1 UNION ALL SELECT 1 SELECT IDD=IDENTITY(INT,1,1),* INTO #T FROM @TBSELECT ID FROM #T T WHERE IDD=(SELECT MIN(IDD) FROM #T WHERE ID=T.ID) ORDER BY IDDID ----------- 2 3 1(所影响的行数为 3 行)
order by 聚集索引
INSERT @TB
SELECT 2 UNION ALL
SELECT 3 UNION ALL
SELECT 1 UNION ALL
SELECT 1 SELECT IDD=IDENTITY(INT,1,1),* INTO #T FROM @TBSELECT ID FROM #T T WHERE
IDD=(SELECT MIN(IDD) FROM #T WHERE ID=T.ID) ORDER BY IDDID
-----------
2
3
1(所影响的行数为 3 行)