/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 vote300 views1 answer
Oracle sql drop table
SQL
0 vote300 views1 answer
Mysql coonect sample code
SQL
0 vote317 views1 answer
Renommer base sql
SQL
2 votes367 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote293 views1 answer
Get who is hired in specific month in sql
SQL
-2 votes325 views1 answer
How-to-remove-mysql-root-password
SQL
1 vote302 views1 answer
Moodle query first user access
SQL
0 vote281 views1 answer
Insert or update cassandra
SQL
0 vote294 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote297 views1 answer
How to check xampp mysql password
SQL

Share