sqlserver row_number() 未排序问题

发布时间：2020-12-12 13:03:45 所属栏目：MsSql教程来源：网络整理

导读：在整个sql外面来一个order by就可以了 (select distinct * FROM (SELECT *,row_number() OVER (ORDER BY name)? AS rnum FROM TempView? where 1=1 ) A WHERE A.rnum BETWEEN 1 and 40) ORDER BY name ??

在整个sql外面来一个order by就可以了

(select distinct *
FROM (SELECT *,row_number() OVER (ORDER BY name)? AS rnum FROM TempView?
where 1=1 ) A WHERE A.rnum BETWEEN 1 and 40) ORDER BY name

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!