gaps-and-islands Examples and Free Source Code

PostgreSQL cluster uninterrupted series of data...

sql postgresql window-functions gaps-and-islands

Postgres Select Row From Group With Opposite Sort Order...

sql postgresql window-functions gaps-and-islands

How to replace null values with the last preceding not-null value?...

sql postgresql null gaps-and-islands

MySQL query to find the customers who have placed orders on consecutive days...

mysql window-functions gaps-and-islands

Query to sum over multiple rows based on column...

sql postgresql gaps-and-islands

Values based on preceding rows: when x>2 then repeat 1, when x=0 for 3 consecutive rows then repe...

sql postgresql sas window-functions gaps-and-islands

How to get previous record by date in case of no match in a join condition...

sql database postgresql window-functions gaps-and-islands

PostgresSql backfill data if doesn't exist for a start period...

sql postgresql time-series window-functions gaps-and-islands

Group by columns when date ranges are contiguous...

sql sql-server common-table-expression gaps-and-islands

Get records that have exactly (n) records in a row continuously...

sql sql-server gaps-and-islands

Cross timeline count across subscriptions for customers...

sql mysql intervals gaps-and-islands

Oracle rank a chronological range of records based on a condition...

sql gaps-and-islands oracle12.2

Update duplicate values to the next free number...

sql postgresql gaps-and-islands

Create dummy column that indicates when something happened between an interval...

sql sql-server gaps-and-islands

Get combined intervals for overlapping sessions...

sql postgresql intervals gaps-and-islands

Count contiguous occurrences of the same value in a table...

sql sql-server lag gaps-and-islands

Contiguous Gaps and Islands with Integers and Group By...

sql sql-server azure-sql-database common-table-expression gaps-and-islands

sql: how to find consecutive dates where condition is met in aggregate...

sql sql-server gaps-and-islands azure-sql-managed-instance

Grouping data by Start/Enddate...

sql sql-server t-sql row gaps-and-islands

How to calculate a user's daily streak?...

sql postgresql query-optimization window-functions gaps-and-islands

Find the latest streak...

sql sqlite gaps-and-islands

SQL Query to show gaps between multiple date ranges...

sql stored-procedures gaps-and-islands

Combine chain of dates where dates are less than few seconds apart...

sql-server lag gaps-and-islands lead

SQL count results in groups, with repeating groups...

sql sqlite count gaps-and-islands group

SQL window functions - how to assign a trip number...

sql sql-server gaps-and-islands

find a gap in a given date range/year with multiple or single date ranges in Oracle SQL...

sql gaps-and-islands oracle19c

How can I create an intelligent grouping in T-SQL to group a dataset based on an ascending DATE valu...

sql sql-server t-sql gaps-and-islands

Ranking by groups of continuous equal values...

sql postgresql oracle-database rank gaps-and-islands

Consecutive Absent Students Excluding Holidays...

mysql gaps-and-islands

Gap/Island problem, consecutive days flagged with reset...

powerbi gaps-and-islands