gaps-and-islands Examples and Free Source Code

In PostgreSQL, how to get number of event per day between a period including days without events (0 ...

postgresql date count gaps-and-islands generate-series

SQL Server (terminal result) hierarchy map...

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

Summarized punch shifts for overlapping clock outs and ins...

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

How to group the same values which is in sequence order...

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

How do I populate the Null Values based on Previous months value, when there are multiple continues ...

sql sql-server sql-update gaps-and-islands

PostgreSQL fill in the blanks in an outer join...

sql postgresql window-functions gaps-and-islands

Is there a way to only show the first date of a 5 day streak?...

mysql sql mysql-workbench gaps-and-islands mysql-5.7

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

sql postgresql gaps-and-islands

Gaps and island combined with a recursion...

sql postgresql recursive-query gaps-and-islands

how to combine product with Period of validity using LEAD function in oracle?...

sql oracle-database gaps-and-islands

Detect biggest date overlap entity...

sql oracle-database gaps-and-islands

How to group timestamps into islands (based on arbitrary gap)?...

sql postgresql time-series window-functions gaps-and-islands

Group Number for similar values...

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

Jump SQL gap over specific condition & proper lead() usage...

sql postgresql gaps-and-islands postgresql-8.4 window-functions

min/max number by group, with recurring group criteria...

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

How can I delete trailing contiguous records in a partition with a particular value?...

sql sql-server gaps-and-islands

How to get longest consecutive same value?...

sql sqlite window-functions gaps-and-islands

Basing OFFSET on another query?...

sql postgresql aggregate-functions sql-delete gaps-and-islands

Count number of null rows along with the first non null row and reset the count after that...

sql google-bigquery count gaps-and-islands gaps-in-data

SQL - select column value of previous matching row...

sql window-functions gaps-and-islands

SQL, rank for each instance of a partition...

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

Analytic function/logic to get min and max record date in Oracle...

sql oracle-database oracle11g gaps-and-islands

Rank a subset of data containing duplicates...

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

How to make non-sequential ranges unique?...

t-sql gaps-and-islands scd

Finding multiple consecutive dates (datetime) in Ruby on Rails / Postgresql...

sql ruby-on-rails postgresql datetime gaps-and-islands

Oracle SQL Grouping In Ranges...

sql oracle-database grouping gaps-and-islands

Dates across multiple rows...

sql-server gaps-and-islands

Query SQL group by per next row if have same value?...

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

Gap-and-island for more than time threshold...

sql postgresql gaps-and-islands

SQL - Condense rows with consecutive IDs...

mariadb gaps-and-islands