Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in gaps-and-islands

SQL Split Island On Criteria

How to group by continuous records in SQL

sql : get consecutive group 'n' rows (could be inbetween)

Finding Product Switches on Account Between Dates

Deriving continuous history from overlapping from/to periods, with gaps [duplicate]

SQL - Condense rows with consecutive IDs

mariadb gaps-and-islands

SQL - Select records that their columns do not follow the same order

Need Oracle sql query for grouping the date

Count of Sequential occurrences and their lengths (advanced gaps and islands problem)

Correlating users with one another in SQL query

SQL How to retrieve first row when value changed?

mysql sql gaps-and-islands

Gaps and island combined with a recursion

Combine 2 rows into 1 row (Start and End times)

Get maximum number of consecutive duplicate records in mysql

mysql sql gaps-and-islands

Select only the least unique value of 2 consecutive rows within a group

Find gap between values of the same type in sql

Get Max And Min dates for consecutive values in T-SQL

Count the most recent number of consecutive rows with a null value

How to count number of non-consecutive values in a column using SQL?

Create Historical Table from Dates with Ranked Contracts (Gaps and Islands?)