Re: ROWNUM question??

From: Aj <ajkumar_at_earthlink.net>
Date: Tue, 19 Jan 1999 19:26:41 -0500
Message-ID: <7837qv$fc7$1@ash.prod.itd.earthlink.net>

Oracle rownum wouldnever be 1. They are long crazy numbers... Try this rownum < 2

Aj
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 Tue Jan 19 1999 - 18:26:41 CST