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

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

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

select * from student        
limit 9,1;                              /* skip 9 rows and get next 1 row */


/****************************************/
/* Limiting the number of returned rows */
/* Oracle                               */
/****************************************/
select * from student 
fetch first 1 row only;                 /* get 1st row only */

select * from student 
fetch first 10 rows only;               /* get first 10 rows */

select * from student        
offset 9 rows fetch next 1 row only;    /* skip 9 rows and get next 1 row */