/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 vote341 views1 answer
On update current_timestamp jpa
SQL
0 vote304 views1 answer
Denied
SQL
1 vote381 views2 answers
Postgres select from last 3 months
SQL
0 vote333 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote349 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote362 views1 answer
Datagrip go to line
SQL
0 vote358 views2 answers
How to know the character set of an oracle databes
SQL
28 votes385 views6 answers
Foreign key
SQL
0 vote345 views1 answer
Sql server whoami
SQL
0 vote360 views1 answer
How to select even id in sql
SQL

Share