gaps-and-islands Examples and Free Source Code

Removing duplicates in a sequence...

sql sql-server t-sql window-functions gaps-and-islands

SQL interview question...

sql gaps-and-islands

Grouping after sorting...

sql sqlite aggregate gaps-and-islands

How do I group on contiguous ranges?...

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

Get a list of dates between two dates...

mysql sql date gaps-and-islands

Changing data structure from "Date" to "From_Date" and "To_Date" based...

sql teradata gaps-and-islands teradatasql

Find the Active Item for a Given Date With Time Intervals and Item Criteria...

sql sql-server gaps-and-islands

SQL explode records that have overlapping date ranges...

sql sql-server gaps-and-islands

Create Iterative Groups in SQL where certain thresholds start a new group number...

sql google-bigquery gaps-and-islands

Using SQL Server window functions with year and month(Period of time)...

sql sql-server window-functions gaps-and-islands

SUM unique GROUP BY values in sqlite and count groups of consecutive values...

sql sqlite gaps-and-islands

Gaps and Islands Getting Last Island Window...

sql sql-server gaps-and-islands

Concat the first and last sequential line number with a hyphen...

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

Detect 1st row of an ordinal chain using recursive CTE or alternative...

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

Query that groups rows based on the difference between datetime column value from a previous row?...

sql-server t-sql gaps-and-islands

Postgres Fixed 7-day window shifting data...

sql postgresql gaps-and-islands

SQL Gaps and Islands with multiple overlapping criteria...

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

Calculate Date Difference for Non-Consecutive Months...

sql sql-server t-sql window-functions gaps-and-islands

Sum a Column of a Timeseries by an Order Number when the Ordernumber is not unique...

sql postgresql window-functions gaps-and-islands

min/max date range within group...

sql postgresql datetime window-functions gaps-and-islands

Copy an ID to rows with adjacent timestamp ranges sharing a class...

sql postgresql window-functions gaps-and-islands

Roll Up with column changes...

sql sql-server gaps-and-islands

Streak for a given endDate SQL (Postgres)...

sql postgresql window-functions gaps-and-islands

How to calculate average stock status in day...

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

How to GROUP_CONCAT row values, but break groups by an arbitrary "gap" flag?...

sql sqlite gaps-and-islands group-concat

Insert missing rows in time series consumption history...

sql postgresql amazon-redshift gaps-and-islands apache-superset

Select rows without overlap / dynamic 1 hour intervals...

sql mysql intervals gaps-and-islands

Windowing Function To Keep Track Of "Latest Seen" Row...

sql sql-server gaps-and-islands

How to label groups in postgresql when group belonging depends on the preceding line?...

sql postgresql window-functions gaps-and-islands

Find a gap > 10min and select begin/end dates in timestamp logs...

sql oracle-database gaps-and-islands