/SQL/Sql groub by count

Sql groub by count

Sql groub by count

SELECT COUNT(Id), Country 
  FROM Customer
 GROUP BY Country

1

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

15 votes181 views3 answers
Mysql update add to existing value
SQL
3 votes168 views2 answers
Sql random integer
SQL
0 vote190 views1 answer
Sql find gaps in date ranges
SQL
0 vote201 views2 answers
Suse Linux restart MySQL
SQL
0 vote183 views1 answer
Sql select where more than one record exists
SQL
8 votes171 views1 answer
Oracle add months to sysdate
SQL
10 votes184 views4 answers
Else if mysql
SQL
0 vote175 views2 answers
Update all columns in one update
SQL
0 vote185 views1 answer
Mysql timediff
SQL
0 vote175 views2 answers
How to get json data mysql
SQL

Share