gaps-and-islands Examples and Free Source Code

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

SQL query to aggregate data into shifts based on time of events?...

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

Perform Value Count with Specific Conditions inside subwindows SQL Presto...

sql window-functions amazon-athena presto gaps-and-islands

Detect gaps between dates in SQLite...

sql sqlite gaps-and-islands

Postgres Consecutive Days, gaps and islands, Tabibitosan...

sql postgresql gaps-and-islands

Find gaps of a sequence in SQL without creating additional tables...

sql postgresql gaps-and-islands

How Do I Find a Gap In a Sequence in PostgreSQL?...

sql postgresql gaps-and-islands

Transform a table based on date overlap...

sql mysql date overlap gaps-and-islands

Group records by continuous date periods in SQL...

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

Query to find unique time periods from list of time ranges...

sql postgresql gaps-and-islands postgresql-9.6

Gaps and Island problem - SQL Server - Snapshot model...

sql sql-server gaps-and-islands

Sum Consecutive Months Based on Groups with Criteria where Only Certain Months Show...

google-bigquery window-functions gaps-and-islands

GROUP BY for continuous rows in SQL...

mysql grouping gaps-and-islands

Inserting "missing records" in a CTE with dates as a key...

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

Postgresql problems...

sql postgresql window-functions gaps-and-islands

Build a timeline based on separate tables with multiple dateFrom and DateTo columns?...

sql sql-server datetime gaps-and-islands timeline