SQL to find the number of distinct values in a column

by

You can use the DISTINCT keyword within the COUNT aggregate function:

SELECT COUNT(DISTINCT column_name) AS some_alias FROM table_name

This will count only the distinct values for that column.

More Related Contents:

  1. How do I (or can I) SELECT DISTINCT on multiple columns?
  2. SQL/mysql – Select distinct/UNIQUE but return all columns?
  3. Is there any difference between GROUP BY and DISTINCT
  4. Group by minimum value in one field while selecting distinct rows
  5. How to use DISTINCT and ORDER BY in same SELECT statement?
  6. Eliminating duplicate values based on only one column of the table
  7. sql query distinct with Row_Number
  8. MySQL: Select DISTINCT / UNIQUE, but return all columns?
  9. Huge performance difference when using GROUP BY vs DISTINCT
  10. Produce DISTINCT values in STRING_AGG
  11. SQL distinct for 2 fields in a database
  12. How to select records without duplicate on just one field in SQL?
  13. Select distinct from multiple fields using sql
  14. SQL query with distinct and sum
  15. When do I need to use a semicolon vs a slash in Oracle SQL?
  16. SQL – HAVING vs. WHERE
  17. dplyr left_join by less than, greater than condition
  18. Parse comma-separated string to make IN List of strings in the Where clause
  19. why is null not equal to null false
  20. calculate a sum of type time using sql
  21. What does the “@” symbol do in SQL?
  22. How to store image in SQL Server database tables column [duplicate]
  23. Procedure or function !!! has too many arguments specified
  24. How to efficiently delete rows while NOT using Truncate Table in a 500,000+ rows table
  25. SQL performance: WHERE vs WHERE(ROW_NUMBER)
  26. Built-in function to capitalise the first letter of each word
  27. How do I list all tables in a schema in Oracle SQL?
  28. oracle sql: update if exists else insert [duplicate]
  29. What is the meaning of SELECT … FOR XML PATH(‘ ‘),1,1)?
  30. SQL Sort Order with Null values last

Leave a Comment