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: Recursive Query
3 ways to remove duplicate data
Duplicate data can be generated in the database due to design error, software bugs or misuse by end users. Depending[…]
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