DISTINCT removes duplicate values from your query results. Essential for finding unique entries in your data.

Basic DISTINCT Syntax

SELECT DISTINCT column FROM table;

Single Column DISTINCT

SELECT DISTINCT country FROM customers;

Multiple Column DISTINCT

SELECT DISTINCT country, city FROM customers;

DISTINCT with COUNT

SELECT COUNT(DISTINCT category) as unique_categories FROM products;

DISTINCT with ORDER BY

SELECT DISTINCT category FROM products ORDER BY category;

DISTINCT vs GROUP BY

-- Both return unique values

SELECT DISTINCT status FROM orders;

SELECT status FROM orders GROUP BY status;

Generate DISTINCT Queries

Need unique values? AI2sql adds DISTINCT automatically when needed.