DISTINCT

A SELECT option that removes duplicate rows from a result.

What does DISTINCT do in a relational database?

DISTINCT — A SELECT option that removes duplicate rows from a result.

SELECT DISTINCT status
FROM purchase_order;

Level: Novice · More Database terms at this level

Updated September 27, 2026