Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can I ask for a ROW
It's a really good solution but witch is the order i get from the table...
because i can't do:
> select *
> from
> (
> select t.*, rownum as r
> from t
> where rownum <= 5 ORDER BY MyRow
> )
> where r = 5;
"Andy Triggs" <andrew.triggs_at_businessobjects.com> escribió en el mensaje
news:2b6e86d0.0207050240.14637c3d_at_posting.google.com...
> How about this?
>
> select *
> from
> (
> select t.*, rownum as r
> from t
> where rownum <= 5
> )
> where r = 5;
>
> Regards, Andy
>
> "Oscar" <oscar_ll_at_jofre.com> wrote in message
news:<ag3fn1$jog$1_at_nsnmrro2-gest.nuria.telefonica-data.net>...
> > Can I make any select for ask for a row pos I mean if I can do any
select
> > direct for get the 5th row ? Without any col tha has rownumber ?
> >
> > Thanks.
Received on Tue Jul 09 2002 - 05:08:11 CDT
![]() |
![]() |