/* Limiting the number of rows returned */
/* MySql and SQLite */

select * from student 
limit 1;                    /* get the 1st row */

select * from student 
limit 10;                   /* returns first 10 rows */

select * from student        
limit 1 offset 9;           /* skip 9 rows and return 1 row */

select * from student       /* the same */        
limit 9,1                   /* skip 9 rows and return 1 row */