New posts in Gaps And Islands

Check if contiguous date interval exists

Find "n" consecutive free numbers from table

Select longest continuous sequence

Gaps And Islands: Splitting Islands Based On External Table

Can window function LAG reference the column which value is being calculated?

Detect consecutive dates ranges using SQL

Trouble using ROW_NUMBER() OVER (PARTITION BY ...)

How to fill timestamp gaps in a Postgres query?

How to check any missing number from a series of numbers?

How to find gaps in sequential numbering in mysql?