/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 vote107 views1 answer
Char varchar nvarchar sql
SQL
9 votes138 views3 answers
Pyodbc connect to sql server
SQL
0 vote116 views1 answer
Oracle table free space
SQL
1 vote108 views1 answer
DATE_SUB postgres
SQL
3 votes109 views1 answer
Set default today mysql
SQL
0 vote63 views0 answer
SQL
1 vote124 views1 answer
UseSqlServer no definition
SQL
2 votes99 views1 answer
Sqlite3 show columns name
SQL
0 vote130 views1 answer
Implode in sql query
SQL
7 votes109 views4 answers
Database dump mysql command
SQL

Share