Re: Select subset of rows

Of course immediately after sending the last message and logging off my
ISP I figured out the simpler way for the third one:

begin;
select salary into temp saltemp from employee order by salary desc limit 5;
select name from employee where exists (select * from saltemp wheresaltemp.salary=employee.salary);
end;

Stephan Szabo
sszabo@bigpanda.com

On Sun, 27 Aug 2000, Paulo Roberto Siqueira wrote:

>     Hi folks,
> 
>     I have this table
> 
> CREATE TABLE EMPLOYEE (ID_EMP INT4 PRIMARY KEY, NAME VARCHAR(35), SALARY
> NUMERIC(5,2));
> 
>     I want to select only the employees' names who have the 5 highest salaries.
> 
> 
> 
> 
> Paulo Siqueira
>