/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

1 vote380 views1 answer
OstgreSQL version
SQL
1 vote394 views1 answer
Oracle insert multiple rows into same table
SQL
0 vote344 views1 answer
Remove default constraint sql server
SQL
0 vote376 views1 answer
SQL column name Oracle
SQL
0 vote366 views1 answer
Connect by query in oracle
SQL
0 vote371 views1 answer
Mysql check if lowercase
SQL
1 vote383 views1 answer
Oracle difference between two dates in years
SQL
2 votes359 views1 answer
Sql server conection string
SQL
0 vote355 views1 answer
Import big data to mysql
SQL
0 vote373 views2 answers
How to install mssql on mac
SQL

Share