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.