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

8 votes133 views1 answer
Oracle all_source package body
SQL
0 vote132 views1 answer
What does leave do in mysql
SQL
2 votes128 views1 answer
Import database in mysql command line xampp
SQL
0 vote128 views1 answer
Back up stored procedures mysql
SQL
0 vote142 views1 answer
Mysql min value row
SQL
10 votes137 views1 answer
All_dependencies
SQL
0 vote267 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote129 views1 answer
Postegresql update to null
SQL
0 vote151 views1 answer
Delete a temporary table mysql
SQL
9 votes147 views6 answers
Check constraint in sql
SQL