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

This article is about how to solve the problem of not sorting when using ROW_NUMBER in sqlServer. I think it is very practical, so I share it with you. I hope you can get something after reading this article. Let's take a look at it.

Set sqlServer not to sort when using ROW_NUMBER

-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. I 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

The sort is:

Select Row_number () over (order by Oper_Date desc) AS ROWNUM,* FROM Product

The above is how to solve the problem that sqlServer does not sort when using ROW_NUMBER. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.