gaps-and-islands Examples and Free Source Code

T-SQL - Return the most recent hire date for each record...

sql t-sql window-functions gaps-and-islands

How to use Pandas to solve Gap and Island problem with dates?...

python pandas group-by gaps-and-islands

SQL interview question...

sql gaps-and-islands

How to summarize days by a flag field?...

sql db2 window-functions gaps-and-islands

Count consecutive occurrences in sql and/or pandas...

python sql pandas gaps-and-islands

How to find oldest Date Range without Gap...

sql sql-server gaps-and-islands

splitting start and end date to start_date / first day of month and end_date / last day of month...

sql presto gaps-and-islands trino

How to write "streak" query?...

sql sql-server common-table-expression gaps-and-islands date-arithmetic

ROW_NUMBER OR OTHER SEQUENCE DEPENDING ON DATE (SQL)...

sql hive sequence gaps-and-islands row-number

Get start and end date time based on sequence of rows...

sql postgresql gaps-and-islands

How to make LAG() ignore NULLS in SQL Server?...

sql sql-server window-functions gaps-and-islands sql-null

Conditional preceding values...

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

SQL Gaps and Islands fails with 3 rows...

sql postgresql window-functions gaps-and-islands

From single Date column to Date Ranges, Ignoring certain columns...

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

Assign GROUP_ID to rows based on start/end tags...

sql oracle gaps-and-islands group oracle18c

Fill in rows per group for pivoting...

sql oracle gaps-and-islands oracle18c gaps-in-data

I wanna get query result Group By and Orderd by Date...

sql oracle gaps-and-islands

Temporal clustering in SQL...

sql presto gaps-and-islands trino

T-SQL query to find the most consecutive number of under par scores in a golf database...

sql sql-server aggregate-functions gaps-and-islands

How do I group by values, but only when they're consecutive?...

sql-server group-by case gaps-and-islands string-aggregation

Counting consecutive blocks in SQL...

mysql sql gaps-and-islands

Records with DateFrom and DateTo - date range optimalization...

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

SQL: Merge almost identical lines with start_date and end_date...

sql postgresql window-functions gaps-and-islands

Assigning a line number based on overlapping dates...

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

Compensating for NULL values in SQL Queries...

sql sql-server greatest-n-per-group window-functions gaps-and-islands

Get most recent streak (consecutive days) for given event and time zone...

sql postgresql window-functions gaps-and-islands timestamp-with-timezone

Relative 60-Day Groups in SQL Server...

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

How to Group Similar Rows in Sql?...

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

Gathering information from parent record to child records...

mysql sql gaps-and-islands

Lag() to get what a value changes to snowflake...

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