Shulou(Shulou.com)06/01 Report--

Editor to share with you how to use the characteristics of SQL Server ROW_NUMBER for paging, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Paging by using the feature ROW_NUMBER in SQL Server

SELECT * FROM (SELECT ROW_NUMBER () OVER (ORDER BY ID DESC) AS ROWID,* FROM TestTable) AS mytable where ROWID between 21 and 40 is all the content of the article "how to use the feature ROW_NUMBER in SQL Server for paging". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.