/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 vote154 views1 answer
Sql server change schema of a table
SQL
0 vote156 views1 answer
Pip install mysqlclient error
SQL
2 votes168 views1 answer
Power query concatenate
SQL
0 vote189 views1 answer
Time data type in mysql
SQL
0 vote147 views2 answers
Postgresql change user role grant
SQL
0 vote145 views3 answers
Average salary in sql
SQL
8 votes142 views1 answer
How to remove tables from postgresql
SQL
0 vote155 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
5 votes149 views1 answer
Oracle scan source ddl
SQL
0 vote220 views1 answer
Mysql collation portugues brasil
SQL

Share