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

select * from student 
fetch first 1 row only;                 /* get the 1st row */

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

select * from student        
offset 9 rows fetch next 1 row only;    /* returns the 10th row only */