/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 vote317 views1 answer
Where case insensitive like mysql
SQL
1 vote352 views1 answer
T-SQL / AZURE Reseed
SQL
0 vote346 views1 answer
Set engine to innodb
SQL
1 vote336 views2 answers
Get table column names sql laravel
SQL
11 votes329 views1 answer
Mysql text type max length
SQL
8 votes327 views2 answers
Grant all privileges database postgres to user
SQL
0 vote321 views1 answer
Sqlalchemy query join many to many
SQL
7 votes306 views1 answer
Mysql unsafe update
SQL
0 vote332 views1 answer
Postgres drop type
SQL
0 vote297 views1 answer
Postgresql parse json array
SQL

Share