T3CHTT: SQL Tip : Count Multiple Distinct Columns

This query does not work on MS SQL Server Select count(distinct column1, column2) from table1 but this one does Select count(distinct column1) from table1 So how do you count distinct rows across multiple columns? Select count(*) from (select distinct ...

blog.hassantt.com