34,576
社区成员
发帖
与我相关
我的任务
分享
SELECT TOP 5
*
INTO #temp
FROM s
SELECT *
FROM #temp
ORDER BY k DESC
DROP TABLE #temp
SELECT *
FROM ( SELECT TOP 5
*
FROM s
ORDER BY NEWID()
) t
ORDER BY k DESC
SELECT *
FROM ( SELECT TOP 5
*
FROM s
) t
ORDER BY k DESC