/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

2 votes163 views1 answer
Oracle block
SQL
0 vote170 views1 answer
How to show current database in mysql
SQL
0 vote112 views1 answer
Sql delete where x or y or z
SQL
1 vote128 views1 answer
Mysql how to truncate table with foreign keys
SQL
0 vote111 views1 answer
Docker export psql sql
SQL
1 vote106 views1 answer
Error code 1175 mysql fix
SQL
7 votes118 views1 answer
Set sequence value oracle
SQL
0 vote144 views1 answer
Oracle create package specification
SQL
2 votes140 views1 answer
Oracle kill session by sql_id
SQL
0 vote112 views1 answer
Pgsql is not permitted to log in
SQL

Share