/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 vote174 views1 answer
Duplicating a MySQL table with all the data Command
SQL
1 vote183 views1 answer
Import sql file mysql commadn line
SQL
0 vote175 views1 answer
Flexible search query delete table
SQL
4 votes205 views2 answers
Oracle unliock account
SQL
2 votes200 views1 answer
Oracle log files
SQL
0 vote172 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote212 views1 answer
UNION ALL LEFT JOIN
SQL
0 vote165 views1 answer
Console output pl sql
SQL
0 vote180 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote162 views1 answer
Hibernate xml property MySQL url, username and password
SQL

Share