Re: ROWNUM question??

Try rownum <= 1 (starts with 0)

On Tue, 19 Jan 1999 20:55:41 +0100, Oscar Paredes <oscar_at_fib.upc.es> 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
>
Received on Wed Jan 20 1999 - 07:30:31 CST