how to count number of items in a distinct value in sql code example Example: select count of distinct values sql SELECT COUNT (DISTINCT column-name) FROM table-name