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 vote188 views1 answer
How to dump .csv file into mysql
SQL
0 vote177 views1 answer
Postgres week number
SQL
3 votes224 views1 answer
Sql online test questions and answers
SQL
0 vote178 views1 answer
Sqldf change user
SQL
0 vote185 views1 answer
Default order by in mysql
SQL
0 vote191 views1 answer
Adding generated time in row mysql workbench
SQL
17 votes185 views3 answers
Cast in sql server
SQL
0 vote205 views1 answer
Pl sql turn off variable substitution
SQL
0 vote252 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote227 views1 answer
I wanted to select among the rows the highest value in mysql
SQL