Sql find gaps in date ranges

-- Range of missing dates d in table t1
SELECT * FROM (
    SELECT 
  		trunc(d) AS d,
        (SELECT min(trunc(d)) FROM t1 t2 WHERE trunc(t2.d) > trunc(t1.d)) next_d
    FROM t1
) WHERE d <> next_d - 1;

Similar codes

0 vote195 views1 answer
Sql server rtrim everything after character
SQL
4 votes165 views1 answer
Group by mysql and concatenate string
SQL
0 vote185 views1 answer
Oracle step procedure
SQL
1 vote178 views1 answer
Postgresql can you have null foreign key
SQL
0 vote172 views3 answers
Insert query in ci
SQL
0 vote171 views1 answer
Sql server for loop
SQL
1 vote182 views1 answer
Key validation sql
SQL
0 vote150 views1 answer
Mysql undo delete
SQL
0 vote192 views1 answer
Oracle job session
SQL
1 vote165 views1 answer
Mysql find most common value
SQL