Answers for "difference between count and count distinct in table in sql"

select count of distinct values sql

SELECT COUNT (DISTINCT column-name)  FROM table-name

Posted by: Guest on March-06-2020

sql query to find difference between total no. of rows and distinct rows in sql server

select (count(column_name) - count(distinct column_name)) from table_name;

Posted by: Guest on June-08-2021

Code answers related to "difference between count and count distinct in table in sql"