Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL:Getting the 'Nth' records from a table..

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

From: <narayana_ck_at_my-deja.com>
Date: Fri, 24 Sep 1999 18:02:53 GMT
Message-ID: <7sgec3$eql$1@nnrp1.deja.com>


I need to write a SQL query which can get the records from a table with a frequency of 'n'.

Retrieve the 1st, 5th, 10th, 15th, 20th, 25th... rows from a table.

Is there a way to get it straight from SQL??

thanks
ck

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 24 1999 - 13:02:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US