Shulou(Shulou.com)05/31 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.