Information Storage and Retrieval
Pages
(Move to ...)
Home
About Me
▼
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:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment