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

Зворотній Зв’язок