| From: | JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Advise with a select statement |
| Date: | 2011-04-21 17:05:30 |
| Message-ID: | BANLkTi=7McV81zDGz3Mp+a1cwme-nQ14Ng@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Date | Subject | |
|---|---|---|---|
| Next Message | Sachin Srivastava | 2011-04-21 17:50:58 | Re: Advise with a select statement |
| Previous Message | Sandy Keathley | 2011-04-21 15:27:04 | pgAdmin vs phpPgAdmin |