34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM ( SELECT * ,
ROW_NUMBER() OVER ( ORDER BY ID ) AS num --这里要有order by
FROM 数据资料表
) AS B
WHERE B.num = 3
SELECT ROW_NUMBER() OVER(ORDER BY (SELECT 1)) AS rid,*
FROM MASTER.dbo.spt_values AS sv
WHERE sv.[type]='P'
但不推荐, 有一个明确的顺序(最好是主键id或其它的唯一字段)是最好的。