select * from
(select *, rownum rn
from
(select * from mytable order by something)
)
where rn between FIRST_ROW_TO_SHOW and LAST_ROW_TO_SHOW
"Marc Leman" <marc.leman_at_cgey.NOSPAMcom> wrote in message
news:9v5aon$efg$1_at_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 - 13:57:55 CST
