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

10 votes348 views2 answers
Show tables in schema oracle
SQL
4 votes340 views1 answer
Select nls_date_format
SQL
18 votes367 views4 answers
Uninstall mysql on ubuntu
SQL
10 votes344 views1 answer
Create table oracle
SQL
0 vote340 views1 answer
Storing RGBA in mysql db
SQL
0 vote347 views2 answers
Mysql regexp match word
SQL
0 vote345 views1 answer
Sql server isnull function nor working count
SQL
0 vote358 views1 answer
Where date in datetime mysql
SQL
0 vote333 views1 answer
Mysql xampp reset root password
SQL
0 vote356 views1 answer
Sql developer connect to sql server
SQL