/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

4 votes144 views1 answer
Adding data to table in sql python
SQL
0 vote151 views1 answer
Check database restore status sql script
SQL
0 vote124 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
7 votes127 views2 answers
Show size database mysql
SQL
0 vote151 views1 answer
Default password for mysql_secure_installation in mac
SQL
0 vote129 views1 answer
Sql find leading space
SQL
3 votes96 views1 answer
V$session not found in oracle
SQL
0 vote125 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote139 views1 answer
Mysql date time string format for marshmellow field schema
SQL
2 votes146 views1 answer
Sql count having
SQL

Share