Cheat Sheet logoCheat Sheet Today
SQL Cheat Sheet/Select distinct values

Remove duplicate rows for the selected expression set.

Back to sheetBrowse commands
Sign in to save
Section: SELECT Basics

Select distinct values

sql
sql
SELECT DISTINCT country
FROM customers;
Explanation

DISTINCT applies to the full selected column combination.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing SELECT Basics
Select all columns
Return all columns from a table.
OpenIn sheetsqlsame section
Select specific columns
Return only the columns you need.
OpenIn sheetsqlsame section
Use column aliases
Rename output columns in query results.
OpenIn sheetsqlsame section
Select literals and expressions
Project computed values directly in the result set.
OpenIn sheetsqlsame section
Filter with equality
Return rows matching an exact value.
OpenIn sheetsql
Sort rows
Order query results ascending or descending.
OpenIn sheetsql