Re: SQL:Getting the 'Nth' records from a table..

Try this

create table tc (k1 number);

 select k1 from (select b.k1, mod(rownum,5) rema from tc b) where rema = 0;

John Chiu Received on Mon Sep 27 1999 - 13:38:53 CDT