Distinct

Distinction is critical if you want to stand out from the crowd

Description

Select all matching rows from the table references after removing duplicates in results. (Databricks SQL Language Reference SELECT)

DISTINCT eliminates duplicate values from the result set. (Snowflake SQL Language Reference SELECT)

Syntax

Databricks

SELECT [ DISTINCT ] { named_expression | star_clause } [, ...]
  FROM table_reference

Snowflake

SELECT [ DISTINCT ]
       {
         [{<object_name>|<alias>}.]<col_name>
         | [{<object_name>|<alias>}.]$<col_position>
         | <expr>
       }
       [ [ AS ] <col_alias> ]
       [ , ... ]
[ ... ]

Sample Source Patterns

Setup data

Databricks

Query

CREATE TEMPORARY VIEW number1(c) AS VALUES (3), (1), (2), (2), (3), (4);

Snowflake

Query

CREATE TEMPORARY TABLE number1(c int);
INSERT INTO number1 VALUES (3), (1), (2), (2), (3), (4);

Pattern code

Databricks

Query

SELECT DISTINCT c FROM number1;

Results

c
3
1
2
4

Snowflake

Query

SELECT DISTINCT c FROM number1;

Results

c
3
1
2
4

Known Issues

No issues were found

Related EWIs

No related EWIs