Collections:
Returning the Second 5 Rows in MySQL
How To Return the Second 5 Rows in MySQL?
✍: FYIcenter.com
If you want to display query output in multiple pages with 5 rows per page, and the visitor wants to see the output for the second page, you need to display query output from row 6 to row 10. You can use the "LIMIT startRow maxRows" clause to return only rows starting from "startRow" to "startRow+maxRows-1". Note that MySQL counts output rows starting with 0.
The following statement returns the second 5 rows first from the fyi_links table:
mysql> SELECT id, url, counts, tag FROM fyi_links ORDER BY counts DESC LIMIT 5, 5; -- the first "5" means starting with row #6. +-----+-------------------+--------+------+ | id | url | counts | tag | +-----+-------------------+--------+------+ | 102 | dba.fyicenter.com | 3 | DBA | | 104 | www.mysql.com | 1 | DBA | +-----+-------------------+--------+------+ 2 rows in set (0.00 sec)
⇒ Merge Outputs from Two Queries in MySQL
⇐ Returning Top 5 Rows in MySQL
2017-12-21, 3211🔥, 0💬
Popular Posts:
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
Where to find reference information and tutorials on MySQL database functions? I want to know how to...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
What Is Transport Network Substrate (TNS) in Oracle? TNS, Transport Network Substrate, is a foundati...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...