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.
