sql show unique and also show count of non uniquer code example Example: select count of distinct values sql SELECT COUNT (DISTINCT column-name) FROM table-name