New posts in Gaps And Islands

Can I calculate ROW_NUMBER() for only consecutive records?

Populating missing data based on previous month-end values

Grouping or Window

Finding missing gaps of data in a table with ~2.5 Million rows

Select rows starting from specified value until another specified value

How to get minimum and maximum for grouped timestamps

Group daily schedule into [Start date; End date] intervals with the list of week days

Query to get queue position for each group

Calculate Total Visits

How do I merge similar records with different validity dates?