/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 vote170 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote185 views1 answer
Manage Database in MySQL
SQL
0 vote173 views1 answer
Cannot start database server xampp mac os
SQL
0 vote176 views1 answer
Luu ckeditor vao mysql
SQL
1 vote182 views2 answers
Mysql filter by date mount
SQL
2 votes189 views1 answer
Guid to string sql
SQL
1 vote204 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote181 views1 answer
Como hacer un select entre fechas mysql
SQL
18 votes143 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote156 views1 answer
Sql min
SQL

Share