/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 votes382 views1 answer
How to check if a row is null in sql
SQL
20 votes350 views1 answer
Sql change column types
SQL
0 vote357 views1 answer
Show mysql account privilleges
SQL
0 vote346 views1 answer
Mysql join column order By and group By
SQL
5 votes316 views1 answer
Oracle ora-00054 causes
SQL
49 votes382 views6 answers
Get duplicate records in sql
SQL
0 vote345 views1 answer
Case insensitive sql
SQL
1 vote347 views1 answer
Oracle stop
SQL
1 vote339 views1 answer
Too many connections mysql
SQL
2 votes330 views1 answer
Anonymous block plsql
SQL

Share