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 vote245 views1 answer
Ms sql unique
SQL
1 vote250 views1 answer
Substr sql last character
SQL
0 vote262 views1 answer
Laravel eloquent get generated sql
SQL
0 vote309 views1 answer
Psql check if sql script is valid
SQL
4 votes273 views3 answers
Is not null sql
SQL
11 votes289 views1 answer
Ddl view
SQL
0 vote283 views1 answer
How to check database engine in mysql
SQL
0 vote253 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote253 views1 answer
List MySQL Table and Index Size
SQL
0 vote286 views1 answer
How to convert external table to managed table in hive
SQL