@emilioeguia
Software Developer - Data Lover
Nothing here yet.
Nothing here yet.
Nov 24, 2022 · 5 min read · Today 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...
Join discussionNov 22, 2022 · 2 min read · Have 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...
Join discussionNov 22, 2022 · 3 min read · 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...
Join discussion