Is there any way using a SELECT statement to determine the Gaps that exist within this table? From the above example, the gap that exists is. The Query: Assuming the fields containing the interval are named Start and Finish gaps between dates and I am completely lost with how to write this. . Or do you want to find the times between an end date, and the next. This will get you all missing days for one year (SQL Fiddle). all_dates generates a list I don't think so, Oracle will help you to find the missing dates. Since, these are data, so all you can do, write some query, which will help. How to find missing values in a sequence with SQL .. I have a scenario where I need to find overlapping or gaps between ranges of dates. You can produce date ranges from startdate to enddate then outer join this data with your table, if the student wouldn't have come consider it as. I have one table with signin date colum and all other colums. You can find other methods to find gaps in a sequence and full New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server TSQL Get Previous values for each group by.