The select statement only returns 100 records. This is due to timeout and resource restrictions. If you want to obtain more records you must use the limit modifier. Any select statement with a limit modifier will try to return all the records indicated in the limit. So, if we have a contacts table with 150 records, this query:
select * from contacts;will return 100 records, while this query:
select * from contacts limit 200;will return the 150 records.
select firstname,contact_no,phone from contacts order by firstname limit 4;Only four records starting from the first
select firstname,contact_no,phone from contacts order by firstname limit 3, 4Only four records starting from the third