Re: Table sampling question

argh.. this is a SQL construct NOT a SQL*Plus construct. look in the SQL reference manual

MLee417633 (mlee417633_at_aol.com) wrote:
: In response to using only sql to return nth rows from a paricular table:
 

: create view tablea_vw as select *, rownum rn from tablea;
: select * from tablea_vw where mod(rn,100) = 0;
 

: This will return every 100th row from tablea. As far as I know, you
: cannot do this directly from one sql statement. The rownum select item in
: the create view clause is a SQL*Plus pseudo column. Refer to the SQL*Plus
: manual for a description if you are not familiar.
 

: Hope this helps.
: Mike Lee leemic_at_versar.com

--
Kirk Bradley
Oracle Corporation
Mainframe and Integration Technologies Group