/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

15 votes260 views2 answers
Sql order by multiple columns
SQL
1 vote314 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
1 vote326 views1 answer
Hangfire clear all jobs
SQL
0 vote268 views1 answer
Mysql shell set time_zone
SQL
1 vote280 views4 answers
Psql check tables command
SQL
0 vote298 views2 answers
Amazon linux postgresql client
SQL
0 vote278 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote269 views1 answer
Oracle list proxy users
SQL
3 votes275 views2 answers
Enter mysql command line
SQL
3 votes274 views2 answers
Df to sql pandas sql achemy
SQL

Share