Re: newbie question about rownum

From: Rod Stewart <rod.stewart_at_afp.gov.au>
Date: Wed, 26 Aug 1998 11:01:09 +1000
Message-ID: <6rvmgq$sa2$1@plutonium.sge.net>

Steve,

If all you are trying to do is get the first name alphabetically you can use the min function. eg,

SELECT MIN(name) FROM Employees;

Regards

Rod Stewart

steve lancour wrote in message <35E351B4.E36B04B0_at_lancour.tcimet.net>...
> I'm trying to query an Oracle table using an order by clause, but am
>only interested in the first row returned by the query. For example, I
>have a table called EMPLOYEES with a column called NAME and want only
>the first record in alphabetical order by name.
>
Received on Tue Aug 25 1998 - 20:01:09 CDT