gaps-and-islands Examples and Free Source Code

min/max number by group, with recurring group criteria...

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

How can I delete trailing contiguous records in a partition with a particular value?...

sql sql-server gaps-and-islands

How to get longest consecutive same value?...

sql sqlite window-functions gaps-and-islands

Basing OFFSET on another query?...

sql postgresql aggregate-functions sql-delete gaps-and-islands

Count number of null rows along with the first non null row and reset the count after that...

sql google-bigquery count gaps-and-islands gaps-in-data

SQL - select column value of previous matching row...

sql window-functions gaps-and-islands

SQL, rank for each instance of a partition...

sql snowflake-cloud-data-platform window-functions gaps-and-islands

Analytic function/logic to get min and max record date in Oracle...

sql oracle oracle11g gaps-and-islands

Rank a subset of data containing duplicates...

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

How to make non-sequential ranges unique?...

t-sql gaps-and-islands scd

Finding multiple consecutive dates (datetime) in Ruby on Rails / Postgresql...

sql ruby-on-rails postgresql datetime gaps-and-islands

Oracle SQL Grouping In Ranges...

sql oracle grouping gaps-and-islands

Dates across multiple rows...

sql-server gaps-and-islands

Query SQL group by per next row if have same value?...

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

Gap-and-island for more than time threshold...

sql postgresql gaps-and-islands

SQL - Condense rows with consecutive IDs...

mariadb gaps-and-islands

sql query to get deleted records...

mysql sql select gaps-and-islands

Gaps and Islands Python dataframe pandas...

python pandas gaps-and-islands

Count events with a cool-down period after each instance...

sql postgresql time-series greatest-n-per-group gaps-and-islands

Grouping based on Lag/Lead...

sql-server t-sql group-by partitioning gaps-and-islands

Finding a consecutive date ranges in ms sql server...

sql sql-server date-range gaps-and-islands

How to create MySQL query that converts rows to columns?...

mysql time-series case window-functions gaps-and-islands

Oracle: select missing dates...

sql oracle gaps-and-islands

A follow up question on Gaps and Islands solution...

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

Find repeating values of a certain value...

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

SQL pivot based on fuzzy condition...

sql t-sql pivot sql-server-2016 gaps-and-islands

A question again on cursors in SQL Server...

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

What is the best approach to comeup with the output below in SQL Server?...

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

How to collapse overlapping date periods with acceptable gaps using T-SQL?...

t-sql gaps-and-islands

Oracle SQL – counter for consecutive equivalent values under specific column...

sql oracle oracle11g gaps-and-islands