JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
STI Handbok Databaskommunikation
Huvudmoment
Databas
Protokoll
API
Säkerhet
MySQL Workbench
Resurser
More
Share
Explore
SQL
DISTINCT SELECTS
DISTINCT SELECTS
The
SELECT DISTINCT
statement is used to return only distinct (different) values.
Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values.
SELECT DISTINCT Syntax
SELECT DISTINCT
column1
,
column2, ...
FROM
table_name
;
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.