/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 vote183 views1 answer
Encrypt password postgresql
SQL
4 votes198 views1 answer
Describe table mysql
SQL
1 vote193 views1 answer
Media sql
SQL
8 votes202 views2 answers
Between operator
SQL
0 vote195 views1 answer
Mysql query to check record exists in database table or not
SQL
2 votes195 views2 answers
Oracle no data found error code
SQL
0 vote201 views1 answer
Sqlalchemy query join many to many
SQL
1 vote200 views1 answer
Raise application error in oracle
SQL
0 vote212 views2 answers
How to count codition
SQL
3 votes189 views3 answers
Stop mysql ubuntu
SQL

Share