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
_________________ M. S. Rakha, Ph.D. Queen's University Canada
