34,590
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([编号] int)
Insert #T
select 1 union all
select 2 union all
select 3 union all
select 1 union all
select 2 union all
select 3
Go
--测试数据结束
SELECT 编号
FROM
(SELECT *, ROW_NUMBER() OVER (PARTITION BY 编号 ORDER BY 编号) rn FROM #T) t
ORDER BY t.rn,t.编号;