Questions
Linux
Laravel
Mysql
Ubuntu
Git
Menu
HTML
CSS
JAVASCRIPT
SQL
PYTHON
PHP
BOOTSTRAP
JAVA
JQUERY
R
React
Kotlin
×
Linux
Laravel
Mysql
Ubuntu
Git
New posts in gaps-and-islands
SQL Split Island On Criteria
Apr 21, 2026
sql
sql-server
gaps-and-islands
How to group by continuous records in SQL
Apr 19, 2026
sql
sql-server
date
window-functions
gaps-and-islands
sql : get consecutive group 'n' rows (could be inbetween)
Apr 19, 2026
sql
postgresql-9.3
gaps-and-islands
Finding Product Switches on Account Between Dates
Apr 12, 2026
sql
sql-server
gaps-and-islands
Deriving continuous history from overlapping from/to periods, with gaps [duplicate]
Mar 28, 2026
sql-server
t-sql
window-functions
gaps-and-islands
recursive-cte
SQL - Condense rows with consecutive IDs
Mar 25, 2026
mariadb
gaps-and-islands
SQL - Select records that their columns do not follow the same order
Mar 20, 2026
mysql
sql
mariadb
window-functions
gaps-and-islands
Need Oracle sql query for grouping the date
Mar 19, 2026
sql
oracle-database
oracle11g
gaps-and-islands
Count of Sequential occurrences and their lengths (advanced gaps and islands problem)
Mar 08, 2026
sql
postgresql
gaps-and-islands
Correlating users with one another in SQL query
Mar 06, 2026
sql
postgresql
gaps-and-islands
amazon-redshift
SQL How to retrieve first row when value changed?
Feb 24, 2026
mysql
sql
gaps-and-islands
Gaps and island combined with a recursion
Feb 22, 2026
sql
postgresql
recursive-query
gaps-and-islands
Combine 2 rows into 1 row (Start and End times)
Feb 16, 2026
sql
sql-server
group-by
window-functions
gaps-and-islands
Get maximum number of consecutive duplicate records in mysql
Feb 16, 2026
mysql
sql
gaps-and-islands
Select only the least unique value of 2 consecutive rows within a group
Feb 09, 2026
sql
oracle-database
gaps-and-islands
Find gap between values of the same type in sql
Feb 03, 2026
sql
database
temp-tables
gaps-and-islands
global-temp-tables
Get Max And Min dates for consecutive values in T-SQL
Feb 03, 2026
sql
sql-server
window-functions
gaps-and-islands
date-arithmetic
Count the most recent number of consecutive rows with a null value
Feb 01, 2026
sql
postgresql
greatest-n-per-group
window-functions
gaps-and-islands
How to count number of non-consecutive values in a column using SQL?
Jan 31, 2026
sql
oracle-database
gaps-and-islands
Create Historical Table from Dates with Ranked Contracts (Gaps and Islands?)
Jan 28, 2026
sql
date
teradata
gaps-and-islands
Older Entries »