/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 vote95 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote134 views1 answer
How to get table current identity value in sql server
SQL
0 vote144 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
10 votes90 views3 answers
Join multiple tables sql
SQL
31 votes108 views3 answers
Sql count(*)
SQL
0 vote116 views1 answer
Query to remove duplicate rows from a table
SQL
15 votes100 views2 answers
How to know the username of postgresql
SQL
0 vote103 views1 answer
Char varchar nvarchar sql
SQL
0 vote111 views2 answers
Close external port 3306 with iptables
SQL
-1 vote109 views1 answer
Sql select data from one database and insert into a different database
SQL

Share