Re: ROWNUM question??

Hi Oscar,

Try this :

select /*+ RULE */ e.name
from employee e, dual d
where e.name = d.dummy(+) and rownum = 1 order by e.name

HTH, Philippe

Oscar Paredes wrote in message <36A4E33D.74474199_at_fib.upc.es>...
>
>Hi all!
>
>I want to select the first row of a SELECT statement
>that have a ORDER BY, like:
>
> select e.name
> from employee e
> where rownum=1
> order by e.name
>
>But,... unfortunatelly... this don't work!! :-(
>
>Someone know how to do this????
>
>
>Thanks,
>Oscar
>
Received on Wed Jan 20 1999 - 10:08:04 CST