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

8 votes274 views3 answers
SQL column name
SQL
0 vote282 views1 answer
Postgresql inheritance
SQL
3 votes274 views2 answers
To_char sql
SQL
2 votes262 views1 answer
Mysql clear screen
SQL
0 vote263 views1 answer
Postgres create extension if not exists
SQL
0 vote257 views1 answer
Exec procedure oracle
SQL
0 vote312 views1 answer
How to check foreign key constraint in sql
SQL
4 votes260 views1 answer
Phone number sql
SQL
0 vote258 views1 answer
Group by sql not ordering issues
SQL
0 vote285 views1 answer
Mysql case when on date
SQL