Search⌘ K

DISTINCT

Explore how to apply the DISTINCT clause in SQL to return unique rows from queries. Understand how it filters duplicate data based on selected columns and practice examples to solidify your skills in working with unique data sets.

We'll cover the following...

DISTINCT CLAUSE

We’ll work with the DISTINCT clause in this lesson. This clause can be used to output unique rows in a result set. Remember DISTINCT is a post processing filter, meaning it is applied to the resulting rows of a query.

Example Syntax

...