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
Tag: Not Exists
SQL: from [Not] In to [Not] Exists in 3 steps
For many people, using noncorrelated subqueries (using In/Not In) seems to be more natural than using Exists/Not Exists and correlated[…]
Read more
Using a recursive query to create a list of dates
In enterprise database systems, one may commonly find business events (e.g. sales, revenue, etc) associated to dates or months. In[…]
Read more