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 vote240 views1 answer
SAP Return
SQL
10 votes214 views4 answers
Primary key sql
SQL
0 vote251 views3 answers
Condition in count sql
SQL
0 vote240 views1 answer
Oracle query to find schema you are working on
SQL
0 vote244 views1 answer
Postgresql create query
SQL
2 votes225 views1 answer
Sql create database
SQL
1 vote223 views1 answer
Xampp import sql file command line
SQL
16 votes228 views4 answers
Mysql import from sql file
SQL
0 vote356 views1 answer
Sql developer export connections
SQL
9 votes231 views3 answers
Show table columns mysql command line
SQL