Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Return the Second 5 Rows
How To Return the Second 5 Rows? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries
✍: 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)
2007-05-11, 6321👍, 0💬
Popular Posts:
What Happens If One Row Has Missing Columns? - XHTML 1.0 Tutorials - Understanding Tables and Table ...
What is the purpose of Replication ? Replication is way of keeping data synchronized in multiple dat...
Can you explain steps in function points? Below are the steps in function points: >First Count ILF, ...
How To Assign Debug Privileges to a User? - Oracle DBA FAQ - Introduction to Oracle SQL Developer In...
What does address of operator do in background? The AddressOf operator creates a delegate object to ...