/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 vote102 views1 answer
How to install postgresql on wsl
SQL
0 vote109 views1 answer
How to find lowest in sql
SQL
2 votes109 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
1 vote108 views1 answer
Wordpress change http to https phpmyadmin
SQL
1 vote102 views1 answer
How to install mysql 8.0 windows service
SQL
12 votes111 views1 answer
Create column sql server
SQL
1 vote102 views1 answer
How to see logical reads in sql server
SQL
7 votes116 views3 answers
Sql server reset auto increment
SQL
7 votes121 views1 answer
Oracle pagination query rownum
SQL
0 vote102 views1 answer
Qt qsql check if table exist
SQL

Share