SQL to find the number of distinct values in a column

Question

SQL to find the number of distinct values in a column

I can choose every one of the distinct values in a column in the accompanying 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?

distinct sql

4 years ago by Kajalsi45d

3 Answers

Login / Signup to Answer the Question.

Login Signup

**akshay1995** · Answer 1 · 2021-06-22T12:36:26

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.

**sandhya6gczb** · Answer 2 · 2021-06-23T09:14:59

This will give you BOTH the distinct column values and the count of each value.



SELECT [columnName], count([columnName]) AS CountOf

FROM [tableName]

GROUP BY [columnName]

**pankajshivnani123** · Answer 3 · 2021-06-28T14:24:55

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

/

C TUTORIAL

C PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

C++ TUTORIAL

C++ PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

PYTHON TUTORIAL

PYTHON HOW TOS

INTERVIEW TESTS

EXECUTE CODE

JAVA TUTORIAL

JAVA CODE EXAMPLES

SPRING TUTORIAL

MORE IN JAVA

COMPUTER ARCHITECTURE

COMPUTER NETWORK

OPERATING SYSTEM

DBMS & SQL

PL/SQL

MongoDB

EXECUTE SQL

ANDROID DEVELOPMENT

GO LANGUAGE

LINUX

DOCKER

HTML TAGS (A to Z)

CSS REFERENCES

SASS/SCSS

KOTLIN

GAME DEVELOPMENT

PHP

GIT GUIDE

JAVASCRIPT

ADVANCED DSA

SQL to find the number of distinct values in a column

3 Answers

Login / Signup to Answer the Question.