CODE EXAMPLE FOR SQL

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;