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;

Source: kb.objectrocket.com

Similar codes

0 vote192 views2 answers
Add colum in sql
SQL
2 votes176 views1 answer
How to select first row of database sql
SQL
2 votes192 views1 answer
How to get weekday from old date in sql
SQL
0 vote187 views1 answer
Query params sql insert python f string
SQL
12 votes212 views6 answers
Change mysql root password
SQL
0 vote198 views1 answer
Mysql update from select on same table
SQL
0 vote203 views1 answer
Postgre query date
SQL
12 votes206 views4 answers
How to check mysql version ubuntu
SQL
9 votes174 views2 answers
Sql limit to 5 results
SQL
10 votes217 views6 answers
Mysql set root password
SQL