Skip to Main Content

How to avoid gaps and overlaps in consecutive start-end dates

It's common for tables to store start and end dates to record a time period. But this brings a challenge: How do you ensure the end of one period is the start of the next? i.e. there are no gaps between periods and no periods overlap? Join this session for a discussion of ways to do this and their trade-offs

Resources

Featured Speakers

  • Speaker

    Chris Saxon


    Oracle Developer Advocate for SQL

Workshop Info

Session Has Completed - 16 May 2023
1 Hour
Write Great SQL Office Hours
English
SQL

Other Upcoming Sessions