SQL select count distinct code example
Example 1: select count of distinct values sql
SELECT COUNT (DISTINCT column-name) FROM table-name
Example 2: sql count distinct group by
SELECT COUNT(DISTINCT program_name) AS Count,
program_type AS [Type]
FROM cm_production
WHERE push_number=@push_number
GROUP BY program_type
Example 3: sql server select rows by distinct column
SELECT a.*
FROM emails a
INNER JOIN
(SELECT email,
MIN(id) as id
FROM emails
GROUP BY email
) AS b
ON a.email = b.email
AND a.id = b.id;