devxlogo

Using MySQL’s LIMIT Command to Control Returned Rows

Using MySQL’s LIMIT Command to Control Returned Rows

Use the following script to select a particular number of rows after a certain row in MySQL:

 SELECT * FROM tblDummy LIMIT 15, 30 

This script returns the first 30 rows after row 15 in the tblDummy table.

devx-admin

Share the Post: