SQL to find the number of distinct values in a column

Question

I can select all the distinct values in a column in the following ways    SELECT DISTINCT column name FROM table name  SELECT column name FROM table name GROUP BY column name    But how do I get the row count from that query  Is a subquery required

User · Answer

select count    from    SELECT distinct column1 column2 column3 column4 FROM abcd   T   This will give count of distinct group of columns

User · Answer

select Count distinct columnName  as columnNameCount from tableName

User · Answer

select count distinct column name   AS columndatacount from table name where somecondition true   You can use this query  to count different distinct data  Thanks

User · Answer

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

User · Answer

This will give you BOTH the distinct column values and the count of each value   I usually find that I want to know both pieces of information   SELECT  columnName   count  columnName   AS CountOf FROM  tableName  GROUP BY  columnName

User · Answer

SELECT COUNT DISTINCT column name  FROM table as column name count    you ve got to count that distinct col  then give it an alias

User · Answer

Count distinct  fieldname    is redundant  Simply Count  fieldname   gives you all the distinct values in that table  It will not  as many presume  just give you the Count of the table  i e  NOT the same as Count    from table

User · Answer

After MS SQL Server 2012  you can use window function too       SELECT column name      COUNT column name  OVER  Partition by column name      FROM table name group by column name

User · Answer

Be aware that Count   ignores null values  so if you need to allow for null as its own distinct value you can do something tricky like   select count distinct my col           count distinct Case when my col is null then 1 else null end  from my table

User · Answer

An sql sum of column name s unique values and sorted by the frequency   SELECT column name  COUNT    FROM table name GROUP BY column name ORDER BY 2 DESC

User · Answer

Using following SQL we can get the distinct column value count in   Oracle 11g           Select count distinct Column Name   from TableName

User · Answer

select count    from    SELECT distinct column1 column2 column3 column4 FROM abcd   T   This will give count of distinct group of columns

[sql] SQL to find the number of distinct values in a column

Examples related to sql

Examples related to distinct