Re: Getting last rows

From: andrey <andrey_at_roz.ru>
Date: Mon, 12 Mar 2001 19:15:35 +0300
Message-ID: <98ismf$26eq$1@josh.sovintel.ru>

rownum is row number BEFORE sort

"Azhdin" <flateric_at_freesurf.fr> wrote in message news:98iqod$7vr$1_at_wanadoo.fr...
> Hello,
>
> how can i get the last rows from a select which have a rownum restriction
:
>
> Select ID_COL from MYTABLE where mycondition and rownum<100 order by
ID_COL
> desc;
>
> With this request i don't have the last entries.
> I am working with Oracle 7.3.4 and Oracle 8.1.6
>
> Best regards
>
>
>
>
Received on Mon Mar 12 2001 - 10:15:35 CST