How to make use of ID greater than how much and SELECT TOP paging statement form in sql

This article mainly introduces how sql uses ID greater than how much and SELECT TOP paging sentence form, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian with you to understand.

Make use of ID greater than how much and SELECT TOP paging statement form

SELECT TOP 10 * FROM TestTableWHERE ID > (SELECT MAX (id) FROM (SELECT TOP 20 id FROM TestTable ORDER BY id) AS T) ORDER BY ID thank you for reading this article carefully. I hope the article "how to use ID greater than how much and SELECT TOP paging sentence form" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!