Home > mailing lists

Advise with a select statement - Mailing list pgsql-novice

From	JORGE MALDONADO
Subject	Advise with a select statement
Date	April 21, 2011 14:05:40
Msg-id	BANLkTi=7McV81zDGz3Mp+a1cwme-nQ14Ng@mail.gmail.com Whole thread Raw
Responses	Re: Advise with a select statement
List	pgsql-novice

If I have a table that has a column where values can be the same, how can I SELECT them?

For example, consider the following table:

--------------------------------------

Team Score

--------------------------------------

T1 500

T2 510

T3 505

T4 499

T5 500

T6 508

T7 505

T8 498

T9 501

As you can see, T1 and T5 have a score of 500; and T3 and T7 have a score of 505. What I want is a SELECT to get only these four records.

Respectfully,

Jorge Maldonado

From: "Sandy Keathley"
Date: 21 April 2011, 12:27:47
Subject: pgAdmin vs phpPgAdmin

From: Sachin Srivastava
Date: 21 April 2011, 14:57:55
Subject: Re: Advise with a select statement