Re: Can I ask for a ROW

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 Fri Jul 05 2002 - 05:40:52 CDT