/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 vote186 views1 answer
Type int in mysql maxlenght
SQL
14 votes217 views2 answers
Sql cast
SQL
1 vote173 views1 answer
Can not connect to mysql server
SQL
1 vote183 views1 answer
Mysql select another database
SQL
2 votes169 views1 answer
Add 2 hours to current time in MySQL
SQL
0 vote177 views1 answer
Sql server express download
SQL
0 vote186 views1 answer
Sql query for displaying age from oldest to youngest
SQL
1 vote184 views1 answer
Tsql find foreign key references
SQL
0 vote198 views1 answer
Sql string contains case sensitive
SQL
0 vote208 views1 answer
Redshift running queries
SQL

Share