Identify missing dates in a table

You have a 100,000 row table with lots of data over the course of a year. You know that ideally you should have a number of transactions for every day of the year. However, you are not sure if you have any gaps of time. How can you find the gaps of time ?

Lots of ways to slice it, but here is how I would do it ...

Pages: 1 · 2 · 3

Categories: OracleSQL
PermalinkPermalink