Select subset of rows

From: "Paulo Roberto Siqueira" <paulo(dot)siqueira(at)usa(dot)net>
To: "PGSQL SQL" <pgsql-sql(at)postgresql(dot)org>
Subject: Select subset of rows
Date: 2000-08-27 19:50:04
Message-ID: NEBBLMEAPMNMMCFDDILOIEKECCAA.paulo.siqueira@usa.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2000-08-27 20:55:30 Re: Select subset of rows
Previous Message Brian C. Doyle 2000-08-27 12:05:31 Time Results Conversion