Count distinct values

sql

SELECT COUNT(DISTINCT customer_id) AS unique_customers
FROM orders;

Explanation

Distinct counts are common in analytics and business reporting.

Learn the surrounding workflow

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

Same sheet · prioritizing Advanced Aggregation

Compute multiple categorized totals in one query.

Open In sheetsqlsame section

Roll up metrics by calendar day.

Open In sheetsqlsame section

Join multiple strings into one value.

Return the current date and current timestamp.

Return different values based on conditions.

Convert strings to uppercase or lowercase.