/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 vote205 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote134 views2 answers
Default constraint in ms sql
SQL
0 vote156 views1 answer
Mysql root localhost run
SQL
0 vote133 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
16 votes149 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote148 views1 answer
View to table sql
SQL
0 vote127 views1 answer
Python mysql query where
SQL
1 vote139 views1 answer
Sql order by where condition
SQL
0 vote129 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
-1 vote128 views1 answer
Extract Data from SQL Server into XML Format
SQL

Share