Re: fetch the nth record in an oracle table

If you must:

select * from (select * from mytable order by something) where rownum < ( 1 number greater than the one you want to see ) MINUS
select * from (select * from mytable order by samething) where rownum < ( number that you want to see )

Note that both order by clauses MUST be the same ....

"Marc Leman" <marc.leman_at_cgey.NOSPAMcom> wrote:

>I mean I would like to see only the nth line that my request - select * from
>mytable order by something - would retrieve.
>
>
>
>"rob" <rob_at_dsdelft.nl> a écrit dans le message de news:
>9v59pf$a0o$1_at_news.tudelft.nl...
>> what's your definition of 'the nth record'?
>> in a relational database records are stored in a non-specific order
>>
>> Rob
>>
>> "dibule" <dibule_at_dibulehome.fr> wrote in message
>> news:9v574l$bm6$1_at_s1.read.news.oleane.net...
>> > Does someone know how to catch the nth record in an Oracle table?
>> >
>> > Thx
>> >
>> >
>>
>>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Tue Dec 11 2001 - 10:50:10 CST