/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

6 votes284 views3 answers
What is where in sql
SQL
0 vote240 views1 answer
Watch mysql command line
SQL
0 vote206 views8 answers
Convert sql query to linq online
SQL
1 vote214 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
0 vote239 views1 answer
How to get data from 2 database
SQL
18 votes225 views6 answers
Drop table if exists
SQL
0 vote220 views1 answer
Sql server remove 0 from left
SQL
1 vote240 views1 answer
Oracle grant select on schema
SQL
1 vote237 views2 answers
One to one and one to many relationship
SQL
33 votes232 views6 answers
Change column name in mysql
SQL

Share