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

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!

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.