Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group