SELECT LIMIT

select * from table LIMIT 3;

select * from table LIMIT 3,5;