count(*) as distinct code example Example: select count of distinct values sql SELECT COUNT (DISTINCT column-name) FROM table-name