Skip to main content

Consecutive Dates, Missing Numbers & Gaps and Islands

Learn Consecutive Dates, Missing Numbers & Gaps and Islands (Advanced SQL Interview Problems, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction Islands are runs of consecutive values; gaps are the holes between them. The trick: subtract a row number from the value. Consecutive values then produce the same constant, which identifies the island.

More lessons in Advanced SQL Interview Problems