you are at Encyclopedia of SQL >> DISTINCT
DISTINCT
DISTINCT is used after SELECT to choose unique columns.
Syntax
SELECT DISTINCT `column_name` FROM `table_name`
Example
Display names and surnames of customers from `orders` table who
places any order.
| id | name | surname | order_value |
|---|
| 1 | Jan | Kowalski | 120 |
| 2 | Franciszek | Nowak | 300 |
| 3 | Michał | Nowak | 200 |
| 4 | Jan | Kowalski | 150 |
query
SELECT DISTINCT `name`,`surname` FROM `orders`
result
| name | surname |
|---|
| Jan | Kowalski |
| Franciszek | Nowak |
| Michał | Nowak |
this same result but without DISTINCT
SELECT `name`,`surname` FROM `orders`
| name | surname |
|---|
| Jan | Kowalski |
| Franciszek | Nowak |
| Michał | Nowak |
| Jan | Kowalski |
[ wróć na górę strony ]
