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