Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in gaps-and-islands

How to find a gap in range in SQL

How can I force SQL Server Group By to respect column order when grouping?

Retrieve IDs with a minimum time gap between consecutive rows

SQL Grouping by sequential occurrences of a value

SQL query to find gaps within a column of dates

How to get select rows that have first occurrences before column value changes in MYSQL8

Grouping in SQL Server

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)