/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

1 vote207 views1 answer
Sql convert month name to number
SQL
0 vote199 views1 answer
Mariadb maximum left join
SQL
2 votes189 views1 answer
Oracle generated column
SQL
0 vote223 views1 answer
Sqlalchemy query join many to many
SQL
2 votes183 views1 answer
Sql to char function with date
SQL
10 votes139 views1 answer
Oracle view dependencies
SQL
0 vote196 views1 answer
Delete duplicate rows
SQL
0 vote205 views1 answer
Sql ignore
SQL
0 vote246 views1 answer
Copy row from db to db mysql
SQL
2 votes252 views2 answers
Postgres set user as superuser
SQL

Share