SQL Limit query for a range of records

Mon Jul 16, 2012 12:25 am

You can limit the range of results using Limit keyword, you need to specify the starting and ending of records range, you can use if for paging in your application, following SQL will return 10 records starting from record 0 or first record.

Code:: SELECT * FROM 'Department' LIMIT 0, 10

Following SQL return 10 records starting from the 31st record.

Code:: SELECT * FROM 'Department' LIMIT 30, 10