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 vote404 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
8 votes382 views1 answer
Oracle search text in all packages
SQL
0 vote344 views1 answer
Sqlalchemy query return only n results
SQL
12 votes327 views4 answers
SQL Where
SQL
9 votes337 views3 answers
Mysql get last id
SQL
35 votes365 views6 answers
Postgres
SQL
0 vote377 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
3 votes343 views1 answer
V$session not found in oracle
SQL
0 vote344 views1 answer
How to update random rows in sql
SQL
2 votes383 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL