Fetching from cursor....

Hello ,
 I want to fecth random rows from a table ... I have defined a cursor
like

EXEC SQL DECLARE C CURSOR FOR SELECT * FROM tablename ;

Now I want to fectch nth row from the table without actually having to
fetch all n-1 rows before i get to the nth row of the table....

Any help is most welcome....
Thanks,
Nilesh.