gaps-and-islands Examples and Free Source Code

Teradata SQL: Calculate number of successive occurrences of error code (and reset on non occurrence)...

sql teradata gaps-and-islands

Restarting sum(over) function based on parameter -Oracle...

oracle datetime sum gaps-and-islands date-arithmetic

Find first OPENED_DATE for every Denied or Accepted date in Postgresql...

sql postgresql datetime greatest-n-per-group gaps-and-islands

How would I extract only the latest week from a select over statement in Hiveql?...

sql hiveql greatest-n-per-group gaps-and-islands

Alternate Numbering rows if the data is the different...

sql sql-server duplicates sql-server-2014 gaps-and-islands

SQL Server : find recent consecutive records that are greater than 5...

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

How to get value only after change...

mysql sql datetime gaps-and-islands

Find records that occur for consecutive times...

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

TSQL - how can I sum values except absolutes...

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

How to missing numbers by 100s in oracle...

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

Add a counter based consecutive dates...

sql sql-server datetime counter gaps-and-islands

Create time intervals based on values in one column / SQL Oracle...

sql oracle datetime gaps-and-islands

SQL -- How do I write a select statement that finds customers who placed orders on 5 consecutive day...

sql sql-server datetime count gaps-and-islands

How to calculate the time of a vehicle continuously at a location in sql...

sql postgresql datetime gaps-and-islands date-arithmetic

SQL - Convert Time Series Events into On/Off Pairs (handling potential missing On's or Off's...

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

Is there an idiom for querying sequences in SQL?...

mysql sql count window-functions gaps-and-islands

Using lag to access previous row value in mysql...

mysql sql datetime mariadb gaps-and-islands

Oracle SQL or PLSQL. Select rows by partitions which values have specific order...

sql oracle subquery window-functions gaps-and-islands

Get maximum of sequence...

sql window-functions gaps-and-islands

PostgreSQL select rows having same column values...

sql postgresql window-functions gaps-and-islands

SQl Query to get an output that resembles the image...

sql sql-server datetime sum gaps-and-islands

Create last modified column with timestamp based on change in another column...

sql postgresql datetime window-functions gaps-and-islands

Group Date ranges with separate groups if other date in between...

sql sql-server gaps-and-islands

SQL Counting Consecutive Days in Date Ranges...

sql sql-server datetime count gaps-and-islands

Gaps and Island...

sql-server date gaps-and-islands

Postgresql - min/max date range within group...

sql postgresql datetime window-functions gaps-and-islands

SQL : Finding duration between 2 events using LEAD/LAG and/or ROW_NUMBER over a partition...

t-sql datetime sql-server-2012 window-functions gaps-and-islands

Grouping rows by value until it changes (grouping includes the first changed value)...

sql window-functions vertica gaps-and-islands

group orders based on crossing date ranges...

oracle group-by self-join gaps-and-islands

find at least 2 consecutive items based on date ranges...

sql oracle gaps-and-islands