Answers for "postgresql filter on"

postgresql filter on

SELECT COUNT(*) AS [column_name],
COUNT(*) FILTER (WHERE {column_name}{comparison_operator}{VALUE} ) 
   AS [column_name]
FROM TABLE_NAME;
# e.g. 
SELECT COUNT(*) AS no_filter,
COUNT(*) FILTER (WHERE id < 6 ) AS with_filter
FROM employee;

Posted by: Guest on November-25-2021

Code answers related to "postgresql filter on"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgresql filter on"

Code answers related to "postgresql filter on"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgresql filter on"

Code answers related to "postgresql filter on"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us