How to solve the problem of not sorting when using ROW_NUMBER in sqlServer

It is believed that many inexperienced people are at a loss about how to solve the problem when using ROW_NUMBER in sqlServer. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Set sqlServer to use ROW_NUMBER without sorting-- 1. Seeing that NHibernate is written in this way, it feels easier to understand (there should be no efficiency problem, right? )-- with is just an alias? [sql] with query as (select ROW_NUMBER () over (order by (select 0)) AS ROWNUM, * FROM Product) select * from query where ROWNUM BETWEEN 5 AND 10-- 2.ROW_NUMBER must refer to over (order by *), sometimes I don't want to sort at all If you want to sort in the original order (sorting also takes time)-- the method is: select ROW_NUMBER () over (order by (select 0)) AS ROWNUM,* FROM Product sorting is: select Row_number () over (order by Oper_Date desc) AS ROWNUM,* FROM Product

After reading the above, have you mastered how to solve the problem of non-sorting when using ROW_NUMBER in sqlServer? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!