Query Aggregate Filter PostgreSQL PSQL | Screencasts | Teachmedatabase #database #postgresql

Did you know?
PostgreSQL provides a very powerful option for all aggregate functions called Filter. This lets you run aggregate functions on the subscope of your query selected rows. These are available for all aggregate function, with the syntax being aggregate_name expression FILTER ( WHERE filter_clause )

TEACHMEDATABASE is focused on helping you become a pro when it comes to databases. If you would like me to cover Filters in more detail or any other topics, let me know in the comments.

Thanks for watching, if you like what you saw, give us a like, and don’t forget to subscribe!

PostgreSQL Documentation on Filters: https://www.postgresql.org/docs/current/sql-expressions.html