Given a PLAYERS table with following columns and c | CodeGalaxy.io

Given a PLAYERS table with following columns and constraints:

-------------------------
| Name    | Constraint  |
|-----------------------|
| PLAYER  | Primary Key |
| TEAM    | Foreign key |
| AGE     |             |
-------------------------

It contains football players from different teams.
Is it necessary to use DISTINCT keyword in the following query to get a list of unique values of TEAM:

SELECT DISTINCT TEAM FROM PLAYERS

Да
Нет

Explanation

PLAYERS table may contain several players from the same TEAM. Therefore, following query:

SELECT TEAM FROM PLAYERS

will return duplicate values for TEAM in this case.
So, yes, it is necessary to use DISTINCT keyword in this context.

distinct

Нравится

Войдите чтобы поставить Нравится
Комментировать

Войдите чтобы прокомментировать
Распространить

Tweet

Тесты по SQL онлайн

Тесты по
SQL

Присоединяйся и изучай SQL

или Узнай больше о Тесты по SQL онлайн

Следи за CodeGalaxy

Мобильное приложение Beta

Get it on Google Play

Обратная Связь