/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 vote253 views1 answer
Grab all records from one table to another oracle sql
SQL
2 votes248 views1 answer
Anonymous block plsql
SQL
5 votes258 views2 answers
Sql conn
SQL
0 vote256 views1 answer
Write sql query to show the details start from digit
SQL
1 vote228 views3 answers
Remove unique key from a table
SQL
0 vote287 views1 answer
Mysql collation portugues brasil
SQL
0 vote442 views1 answer
Get first match in each group mysql query
SQL
0 vote266 views1 answer
Duplix print in Smartforms
SQL
0 vote236 views1 answer
Strat with in sql
SQL
1 vote344 views1 answer
Aqua Data studio postgresql ssl
SQL

Share