Gaps and islands problems involve finding a range of missing values (gaps) or a range of consecutive values (islands) in a sequence of numbers or dates.
Stats
created |
8 months ago |
viewed |
4 times |
editors |
0 |
Recent Hot Answers
Using Row_Number to find consecutive row countFind “n” consecutive free numbers from table
Find which numbers in [1, 161] are not in the result set?
Stored procedure to check for missing fields in a table
Performance tuning for gap analysis of table
more »
Related Tags
sql × 5sql-server × 3
postgresql × 2
window-functions × 2
query-performance
group-by
postgresql-9.0
mysql
mysql-console
stored-procedures
sql-server-2005
cursors
t-sql
oracle
oracle-11g-r2
