/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

18 votes187 views3 answers
Find column name in database
SQL
0 vote239 views1 answer
Mysql wsrep ls
SQL
0 vote213 views1 answer
Java spring boot connect to sql server
SQL
1 vote179 views4 answers
Sequelize migration default value
SQL
2 votes242 views3 answers
Mysql cheat sheet
SQL
0 vote274 views1 answer
Mysql get nested records
SQL
0 vote199 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
-1 vote172 views1 answer
How to use update trigger in sql
SQL
0 vote197 views1 answer
Postgresql using reserved word as column name
SQL
0 vote188 views1 answer
Mysql create index lost connection
SQL

Share