count distinct sql code example
Example 1: mongodb count distinct
db.collection.distinct('field').length
Example 2: select count of distinct values sql
SELECT COUNT (DISTINCT column-name) FROM table-name
Example 3: 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 4: query DISTINCT
SELECT DISTINCT Column_name FROM table_name;