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: Can I ask for a ROW

Re: Can I ask for a ROW

From: Oscar <oscar_ll_at_jofre.com>
Date: Tue, 9 Jul 2002 12:08:11 +0200
Message-ID: <ageckj$90c$1@nsnmrro2-gest.nuria.telefonica-data.net>


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

Original text of this message

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