/SQL/Sql count distinct group by

Sql count distinct group by

Select count of distinct values sql

SELECT COUNT (DISTINCT column-name)  FROM table-name

13

Source: dofactory.com

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

0

Source: stackoverflow.com

Similar codes

-1 vote166 views1 answer
Insert results of a stored procedure into a temporary table
SQL
54 votes285 views6 answers
Sql rename column
SQL
2 votes164 views1 answer
Sqlite show table indexes
SQL
0 vote166 views4 answers
Best data type to represent money in mysql
SQL
0 vote163 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote176 views1 answer
Python connect microsoft sql server
SQL
0 vote191 views1 answer
Oracle winter time change
SQL
1 vote137 views1 answer
Metada in sql
SQL
25 votes220 views5 answers
Mysql replace text
SQL
28 votes174 views4 answers
Show tables mysql
SQL

Share