/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

3 votes309 views2 answers
Mysql time
SQL
0 vote345 views1 answer
Oracle swap partition
SQL
3 votes321 views1 answer
Sql multi column index performance
SQL
1 vote318 views1 answer
Sqlite3 read only
SQL
1 vote315 views1 answer
Sql list all procedures
SQL
3 votes317 views1 answer
Oracle apex warn on unsaved changes
SQL
0 vote340 views1 answer
Sql script get all stored procedures from database
SQL
0 vote365 views1 answer
Oracle sql developer closed connection
SQL
0 vote328 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote318 views1 answer
Dump multiple tables mysql
SQL

Share