/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 vote163 views1 answer
Plsql find location of procedure
SQL
0 vote146 views1 answer
Sql find leading space
SQL
11 votes166 views2 answers
Sql rank
SQL
0 vote146 views1 answer
Grant privileges of databse to user
SQL
2 votes200 views1 answer
Oracle trace session
SQL
1 vote159 views2 answers
Backup table mssql
SQL
0 vote138 views1 answer
Oracle 11g forget password
SQL
1 vote147 views1 answer
Spring postgresql reset auto increment to 0
SQL
0 vote138 views1 answer
Get all employee of salary if more than in sql
SQL
3 votes159 views1 answer
Oracle user privileges
SQL

Share