Return Distinct Values

Use `DISTINCT` to remove duplicate rows from a result set.

5/5 supported engines validation-green 1 example 2 scenarios

Docker-validated Not currently validation-green

Example 1

List unique status values

DISTINCT applies after the selected columns are evaluated, so duplicate values collapse to one row in the result.

Source table data Rows loaded before the example query runs.

Setup

CREATE TABLE orders (id INT, status VARCHAR(20));

INSERT INTO
  orders (id, status)
VALUES
  (1, 'new'),
  (2, 'shipped'),
  (3, 'new');

Validated query Shared across supported engines.

SQL

SELECT DISTINCT
  status
FROM
  orders
ORDER BY
  status;

Expected result Returned rows for the shared example.

status
new
shipped

The result shape is identical because the query orders the deduplicated values explicitly.

Useful when

Where this command helps.

listing the unique values available in a column
removing duplicate rows from a lookup-style result set

Explanation

What the command is doing.

DISTINCT operates on the selected columns, not the underlying table rows. It is useful when you want a unique list of values such as categories, statuses, or regions.

Return Distinct Values

List unique status values

Where this command helps.

What the command is doing.

Keep moving through nearby tasks.