ROWNUM question??

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 Tue Jan 19 1999 - 13:55:41 CST