Received: from giannott.uol.com.br (giannott.uol.com.br [200.231.204.6]) by hub.org (8.10.1/8.10.1) with ESMTP id e7RJnYL86499 for ; Sun, 27 Aug 2000 15:49:35 -0400 (EDT) Received: from maximus (200-191-14-102-as.acessonet.com.br [200.191.14.102]) by giannott.uol.com.br (8.9.1/8.9.1) with SMTP id QAA09340 for ; Sun, 27 Aug 2000 16:49:22 -0300 (BRT) From: "Paulo Roberto Siqueira" To: "PGSQL SQL" Subject: Select subset of rows Date: Sun, 27 Aug 2000 16:50:04 -0300 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Importance: Normal X-Archive-Number: 200008/288 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