Mastering Aggregate Functions in SQLToday we will look into aggregate functions to get a better understanding of how to obtain some data from integer columns. This is a topic you must know and master in order to be more proficient and obtain better data in SQL. An aggregate function pe...Nov 24, 2022 · 5 min reademilioeguia.hashnode.dev
Quick Look Into SQL Order ExecutionHave you ever wondered how SQL executes the queries that you write? In fact, a particular order must be followed to execute it, even if we can't see it. It is very different from the order we write the clauses, keep reading to find out why this orde...Nov 22, 2022 · 2 min reademilioeguia.hashnode.dev
ROW_NUMBER() vs RANK() vs DENSE_RANK()The RANK, DENSE_RANK and ROW_NUMBER functions are used to return an increasing integer number. All of these three functions require the ORDER BY clause to function in the way intended. Before explaining how these functions work, let's understand how...Nov 22, 2022 · 3 min reademilioeguia.hashnode.dev
