EEEmilio Eguiainemilioeguia.hashnode.dev·Nov 24, 2022 · 5 min readMastering 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...00
EEEmilio Eguiainemilioeguia.hashnode.dev·Nov 22, 2022 · 2 min readQuick 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...00
EEEmilio Eguiainemilioeguia.hashnode.dev·Nov 22, 2022 · 3 min readROW_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...00