>_ QueryLocal All recipes
SQL recipe

How do I list the distinct country values in SQL?

SELECT DISTINCT country FROM data;
Run this query in QueryLocal →

`SELECT DISTINCT country` returns each unique value that country takes exactly once, dropping repeats — useful for a quick inventory of what values actually occur in a column before deciding how to filter or group on it.

A table named data with columns: order_id (integer), customer (text), country (text), category (text), quantity (integer), unit_price (real), order_date (text, YYYY-MM-DD).