/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

0 vote193 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
3 votes212 views5 answers
No module named 'MySQLdb'
SQL
0 vote233 views1 answer
Sqlalchemy _in array sqlite
SQL
3 votes185 views1 answer
Get all elements sql
SQL
1 vote196 views1 answer
Sometimes i cant edit sql developer
SQL
5 votes252 views1 answer
Oracle source query
SQL
0 vote188 views1 answer
Sql describe
SQL
0 vote207 views2 answers
Postgresql gset
SQL
0 vote209 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
5 votes190 views3 answers
Truncate function in sql oracle
SQL

Share