34,590
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([name] nvarchar(22))
Insert #T
select N'张三' union all
select N'李四' union all
select N'王五' union all
select N'赵六'
Go
--测试数据结束
SELECT * ,
ROW_NUMBER() OVER ( ORDER BY ( SELECT 0
) ) AS num
FROM #T
ORDER BY num DESC