Row_number paging problem in SQL Server

When using Row_number paging, you may need conditions, such as displaying information below an ID for paging, and so on, which need to be judged by conditions.

SELECT * FROM (select Row_number () over (order by ID) as NUM, * from [SJK] where id=xxx) as T where T.num>=0 and T.NUM&L T;=20

In this there is a clear need to find information about an ID. But this where condition cannot be placed outside, on the outside layer will not be able to find the data.

This article is from the "Music" blog, be sure to keep this source http://boysmusic.blog.51cto.com/9398683/1758855

Row_number paging problem in SQL Server