![SQL Daily on X: "After grouping rows in #SQL, sometimes you want to filter the result of aggregate functions (e.g. count, max, avg) Do this in the HAVING clause, e.g: HAVING COUNT (*) SQL Daily on X: "After grouping rows in #SQL, sometimes you want to filter the result of aggregate functions (e.g. count, max, avg) Do this in the HAVING clause, e.g: HAVING COUNT (*)](https://pbs.twimg.com/media/E-1qlVhWQAIhS7_.png)
SQL Daily on X: "After grouping rows in #SQL, sometimes you want to filter the result of aggregate functions (e.g. count, max, avg) Do this in the HAVING clause, e.g: HAVING COUNT (*)
![Lukas Eder on X: "What performs better, SQL FILTER or CASE? I've benchmarked the performance difference between these two equivalent aggregate function syntaxes on PostgreSQL 15, and indeed, there's a difference! https://t.co/UyLJBHeYu3 Lukas Eder on X: "What performs better, SQL FILTER or CASE? I've benchmarked the performance difference between these two equivalent aggregate function syntaxes on PostgreSQL 15, and indeed, there's a difference! https://t.co/UyLJBHeYu3](https://pbs.twimg.com/media/FoRMK2HX0AItToK.jpg)
Lukas Eder on X: "What performs better, SQL FILTER or CASE? I've benchmarked the performance difference between these two equivalent aggregate function syntaxes on PostgreSQL 15, and indeed, there's a difference! https://t.co/UyLJBHeYu3
![SQL Aggregate Functions for Your Next Data Science Interview | by Iffat Malik Gore | Towards Data Science SQL Aggregate Functions for Your Next Data Science Interview | by Iffat Malik Gore | Towards Data Science](https://miro.medium.com/v2/resize:fit:1400/1*U-sKS4ffWopsSMUf-tbPpg.png)