/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 vote187 views1 answer
How to connect to mysql in ef 6
SQL
1 vote129 views1 answer
Insert into sql
SQL
0 vote187 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
6 votes172 views1 answer
Oracle trigger after logon on database
SQL
0 vote187 views1 answer
How to select only id where is not in column mysql
SQL
0 vote193 views1 answer
Sql get guid
SQL
0 vote231 views4 answers
Best data type to represent money in mysql
SQL
2 votes182 views1 answer
Plsql left() function
SQL
0 vote190 views1 answer
Create schema sql server
SQL
0 vote196 views1 answer
Check for directory in bash
SQL

Share