gaps-and-islands Examples and Free Source Code

Generate new UUID per row depending on gaps in existing time series...

sql postgresql gaps-and-islands postgresql-12

How to copy the previous row value of the same column?...

sql postgresql window-functions gaps-and-islands

grouping rows with less than one minute separating row from previous row in Oracle...

sql oracle-database oracle11g gaps-and-islands

Grouping in SQL Server...

sql-server grouping gaps-and-islands

Merge groups of consecutive rows in T-SQL and sum values from each group...

sql sql-server t-sql gaps-and-islands azure-synapse

algorithm name for island polygons between non overlapping objects...

c#algorithm gaps-and-islands

Count max number of consecutive occurrences of a value in SQL Server...

sql sql-server gaps-and-islands

can we solve basic transaction query using lead and lag window function in sql...

sql oracle-database gaps-and-islands

How to form groups of consecutive dates allowing for a given maximum gap?...

sql postgresql window-functions gaps-and-islands

Count size of islands with no gaps...

sql sql-server sql-server-2012 gaps-and-islands

Find the next free timestamp not in a table yet...

sql postgresql gaps-and-islands

Continuous subset and ranking using sql...

sql postgresql gaps-and-islands

How to get the biggest value in any consecutive range...

mysql window-functions recursive-query gaps-and-islands dense-rank

Self joining a table while maintaining the order of the rows...

mysql sql database gaps-and-islands dbt

Redshift: Find MAX in list disregarding non-incremental numbers...

sql amazon-redshift gaps-and-islands

How to group data based on continuous date range?...

sql sql-server gaps-and-islands

Combine periods by user...

sql sql-server datetime gaps-and-islands

Detect SQL island over multiple parameters and conditions...

sql postgresql gaps-and-islands

How can I create a query using a range of dates and count per month?...

mysql sql gaps-and-islands

Microsoft SQL Server 2016 - T-SQL puzzle - overlapping date ranges in segregated rows - 'Gaps &a...

date t-sql sql-server-2016 gaps-and-islands partition-by

How to find the difference between two timestamped rows whenever value changes between rows in MySQL...

mysql sql gaps-and-islands date-arithmetic

Check date split periods are continuous (and spotting the gaps)...

sql presto gaps-and-islands

Detect flickering in list of durations values...

c#gaps-and-islands

How to aggregate to group level, order and enumerate groups chronologically? (in SQL Server)...

sql-server grouping gaps-and-islands dense-rank granularity

SQL - gap and island issue for more attributes...

sql sql-server gaps-and-islands

create time range with 2 columns date_time...

sql date teradata gaps-and-islands

Count an island and its start and end...

sql oracle-database gaps-and-islands

Trying to add new column with DENSE_RANK() in sequentially...

sql-server gaps-and-islands dense-rank

Oracle SQL - How to return common date periods and "divide" when there are gaps between pe...

sql oracle-database gaps-and-islands

Creating groupings based on criteria...

sql netezza gaps-and-islands