What is SQL DISTINCT?
SQL DISTINCT is a SQL keyword that specifies that only distinct / non-duplicate results are to be returned.
DISTINCT can apply to single columns or to multiple columns.
Why Use SQL DISTINCT?
The DISTINCT keyword can help to understand information. For example, a query containing DISTINCT could return a non-duplicated list of cities where a company does business.
How To Use SQL DISTINCT
SQL DISTINCT is used as follows.
SQL DISTINCT Syntax
The word DISTINCT can be placed in front of a single column name or a number of column names. When in front of multiple column names, a distinct combination is returned.
SQL DISTINCT Example
The following example a DISTINCT list of region_nbr referenced in the branch table is returned.
Here are the contents of the table:
This SQL Statement with DISTINCT is executed:
Here is the result.