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: Missing values
LEAD and LAG: accessing multiple rows without self join
LEAD and LAG are window functions that enable the simultaneous access to a table’s row and to other row related[…]
Read more
Looking for missing values using recursive queries
In most of application databases, we can find one or more numeric columns representing IDs or used as primary keys.[…]
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