/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

10 votes119 views2 answers
SQL rounding numbers
SQL
0 vote134 views1 answer
Mysql remove bad character from all fields
SQL
15 votes119 views4 answers
How to get all tables in sql
SQL
0 vote76 views1 answer
'0000-00-00' for column '
SQL
3 votes127 views2 answers
Find string in stored procedure sql server
SQL
0 vote108 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote142 views1 answer
Alternative for LIMIT sql
SQL
3 votes118 views2 answers
Current year sql
SQL
0 vote123 views1 answer
Including parameters in OPENQUERY
SQL
0 vote108 views1 answer
How to populate a table in MySQL from and existing csv file
SQL

Share