Re: ROWNUM question??

Oscar Paredes wrote:

> 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

where rownum < 2 Received on Tue Jan 19 1999 - 16:34:21 CST