/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 vote322 views2 answers
Soql last year
SQL
0 vote312 views1 answer
Alter owner in PostgreSQL
SQL
1 vote300 views1 answer
User privileges postgresql information_schema
SQL
0 vote307 views1 answer
How to get data between a last week in mysql
SQL
0 vote330 views1 answer
Influxdb clone measurement
SQL
4 votes282 views1 answer
Mac install mysql
SQL
1 vote313 views1 answer
Operator does not exist: integer = text
SQL
0 vote321 views1 answer
Oracle service name view
SQL
1 vote328 views2 answers
Backup table mssql
SQL
3 votes323 views1 answer
Oracle failed login attempts
SQL

Share