RE: Help ...learning SQL

>Please help solve the following queries:-
>1) Find the nth max(sal) in a table.
>2)List the ename,sal of top n number of people.
>Thanks in advance.
>Sharon.

select ename, sal from <table>
where rownum < <top#>
order by sal desc

Ric Received on Sat Aug 10 1996 - 00:00:00 CEST