/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 vote224 views4 answers
How to drop all tables in sql
SQL
3 votes253 views2 answers
Update part of a string in mysql
SQL
-1 vote216 views2 answers
Sql query examples
SQL
1 vote252 views1 answer
Postgresql not in
SQL
-2 votes230 views1 answer
Modify column name in tsql
SQL
0 vote241 views1 answer
Sqlalchemy query join many to many
SQL
0 vote216 views1 answer
Automate mysql cli query
SQL
0 vote231 views1 answer
Get db connection detail from sql developer profile
SQL
4 votes215 views2 answers
How to count items with same name in sql
SQL
0 vote244 views1 answer
Get last date join sql
SQL

Share