Advise with a select statement

Поиск
Список
Период
Сортировка
От JORGE MALDONADO
Тема Advise with a select statement
Дата
Msg-id BANLkTi=7McV81zDGz3Mp+a1cwme-nQ14Ng@mail.gmail.com
обсуждение исходный текст
Ответы Re: Advise with a select statement  (Sachin Srivastava <sachin.srivastava@enterprisedb.com>)
Список 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

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Sandy Keathley"
Дата:
Сообщение: pgAdmin vs phpPgAdmin
Следующее
От: Sachin Srivastava
Дата:
Сообщение: Re: Advise with a select statement