Re: query

Try using the following ( its a bit of a kludge, but it seems to work)

Select salary from emp
where rownum < 2
order by salary desc;

( it makes use of the fact that the rownum pseudocolumn is assigned after the sort is done, so 1 record is returned, the top salary... )

uday_ind_at_my-deja.com wrote:

>Finding the maximum salary from the emp (demo table) without using the
>max function
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Tue Oct 12 1999 - 11:21:02 CDT