/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

2 votes285 views1 answer
Sqlplus clear screen
SQL
0 vote252 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
0 vote274 views2 answers
Alter table add multiple columns mysql
SQL
0 vote253 views1 answer
Postgres select except
SQL
4 votes282 views6 answers
Sql select statement
SQL
15 votes253 views4 answers
Pl sql
SQL
0 vote282 views1 answer
Tsql delete all rows
SQL
6 votes220 views2 answers
Generate c# class from sql server table
SQL
9 votes283 views4 answers
How to alter table column name in mysql
SQL
3 votes256 views1 answer
Mysql load sql from file
SQL

Share