SQL Count(*), Count(cte), Count(column), Count(pk), … x Inner and Outer Joins
In SQL, The Count function counts the number of values in a set. Such function accepts a parameter, that specifies[…]
Read more
Tag: Joins
SQL: 3 ways to find gaps and missing values
It is really common to have columns that stores sequences of numbers in database systems (specially in relational databases). Users[…]
Read more
SQL Inner and (Left/Right/Full) Outer Joins
Joins are one of the most common operators in SQL queries. In this post, we present inner and outer joins[…]
Read more