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

1 vote174 views1 answer
Oracle show execution plan
SQL
0 vote149 views1 answer
Mysql find foreign key references
SQL
3 votes191 views3 answers
1396(hy00) mysql error
SQL
0 vote177 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
1 vote157 views3 answers
Mariadb add foreign key
SQL
9 votes171 views4 answers
How to alter table column name in mysql
SQL
5 votes189 views1 answer
Oracle list functions
SQL
6 votes163 views1 answer
Phpmyadmin password root
SQL
2 votes169 views1 answer
No data found oracle
SQL
0 vote167 views2 answers
Sql having multiple conditions
SQL