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

Editor to share with you how mysql query articles 5 to 10 data, I believe that most people do not understand, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

Mysql query the data in sections 5 to 10: execute the [select top 10 * from TB1 where Id not in (select top 5 Id from TB1)] statement to query.

There are two situations for querying items 5 to 10 in the database:

1. ID is connected, of course, this situation is easier to check. Direct SELECT is fine, as long as ID is greater than 5 and less than 10

This situation is relatively rare.

2. ID is not connected. If you want to take the fifth data to the tenth data, you have to query SELECT from SQL.

Select top 10 * from TB1 where Id not in (select top 5 Id from TB1)

Among them, 10 means: the number of queries, 5 indicates which article to start the search.

The above is how mysql query items 5 to 10 of the data all the content, 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.