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

Home -> Community -> Usenet -> c.d.o.misc -> Re: fetch the nth record in an oracle table

Re: fetch the nth record in an oracle table

From: Marc Leman <marc.leman_at_cgey.NOSPAMcom>
Date: Tue, 11 Dec 2001 17:00:11 +0100
Message-ID: <9v5aon$efg$1@s1.read.news.oleane.net>


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
> >
> >
>
>
Received on Tue Dec 11 2001 - 10:00:11 CST

Original text of this message

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