Google
Information Storage and Retrieval: Query to retreive every Nth row from an Oracle table

Pages

Tuesday, January 19, 2010

Query to retreive every Nth row from an Oracle table

The query is as follows:

select * from my_table where (rowid,0) in (select rowid, mod(rownum,n) from my_table )

No comments: