SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Selecting every nth row

12183Nov 13 2001

Hi
I'm running Oracle v7.3.4.5.0 on an HP Unix system and I need
to create a query that will return me every nth row of a select.
The trick is that I need to order the result set before I select
out every nth row. How do I go about this?

Thanks in advance
Sam

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 12 2001

Added on Nov 13 2001

2 comments

3,064 views