/SQL/Sql count distinct group by

Sql count distinct group by

Select count of distinct values sql

SELECT COUNT (DISTINCT column-name)  FROM table-name

13

Source: dofactory.com

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 vote254 views1 answer
Sum sqlserver
SQL
0 vote270 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
0 vote244 views1 answer
Hallo
SQL
11 votes261 views4 answers
Query DISTINCT
SQL
4 votes319 views3 answers
Mysql get column names from table
SQL
0 vote218 views1 answer
Check id exist or not in sql
SQL
1 vote272 views1 answer
Select last row from SQL Table
SQL
1 vote268 views1 answer
Mysql change root mysql_native_password
SQL
3 votes267 views3 answers
How to add month in update sql
SQL
8 votes259 views1 answer
Mac restore mysql database command line
SQL

Share