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

1 vote73 views1 answer
Mssql string length
SQL
1 vote115 views1 answer
Ilike for date postgres
SQL
0 vote113 views1 answer
Pip install mysqlclient error
SQL
1 vote119 views1 answer
Pl sql create table from another table
SQL
0 vote115 views1 answer
List MySQL Table and Index Size
SQL
1 vote120 views1 answer
Oracle stop
SQL
0 vote107 views4 answers
Sql year
SQL
3 votes113 views1 answer
Export postgres database linux
SQL
1 vote119 views2 answers
Reset mysqli fetch_arra
SQL
2 votes117 views1 answer
Apex execute batch job
SQL