/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 vote245 views1 answer
Count number of entires by months sql
SQL
0 vote232 views1 answer
Testing sql queries
SQL
4 votes196 views1 answer
What are the data types in sql
SQL
7 votes211 views3 answers
Sql server reset auto increment
SQL
2 votes216 views3 answers
How to check current user in mySQL
SQL
-1 vote254 views4 answers
Postgres between dates
SQL
0 vote217 views3 answers
Run sql command line
SQL
1 vote219 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote190 views1 answer
How to get employee having maximum experience in mysql
SQL
1 vote294 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL

Share