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 vote279 views1 answer
Microsoft sql server management studio clear cache
SQL
11 votes362 views5 answers
Update table from another table mysql
SQL
0 vote351 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote345 views1 answer
Frename oracle
SQL
3 votes331 views1 answer
Ms sql skip take
SQL
4 votes399 views4 answers
Mysql get date from datetime
SQL
0 vote325 views1 answer
Mysql workbench not showing schemas
SQL
0 vote351 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
20 votes322 views2 answers
Mysql bigint max value
SQL
-1 vote339 views1 answer
Mysql select all columns and specific fields as
SQL