> 4.How to fetch a n th row in a table (or in a SELECT statement)
> Eg. The student whose rank is 22)

try something like
SELECT FIRST 1 SKIP 21 RANK, STUDENT
FROM STUDENTS
WHERE <some limiting criteria>
ORDER BY RANK

HTH,
Set