Zahir Mohideen·Jun 20Oracle 23c New Feature — Grouping by an aliasProbably , this is my shortest blog post till now. In Oracle 23c , we can group by the alias name . This simple enhancement improves…
Tumini Fubara·Jun 17Understanding SQL Aggregate Functions Using a Simple Classroom AnalogyMrs. Bello finished grading a tall stack of math tests. Now the papers sat in a neat pile on her desk.
Miranjali Mane·May 24Aggregate Functions in SQL | The Data Analytics NotesAfter learning how to retrieve, filter, and manipulate data, the next step is to understand how to perform calculations on data stored in…
InDev GeniusbyRajiv Gupta·Apr 21Snowflake Deep Dive: Unlocking the Power of MIN_BY & MAX_BY— Find the row behind the extreme — the smarter way to aggregate in Snowflake
Quipoin·Jan 19SQL Aggregate FunctionsWhen working with databases, we often don’t just want raw data we want insights.