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 vote159 views1 answer
Plsql trigger insert update
SQL
7 votes219 views1 answer
Oracle reset sequence
SQL
0 vote208 views1 answer
Mysql group by derived column
SQL
0 vote188 views1 answer
Online sql testing tool
SQL
3 votes210 views1 answer
Sql print all names that start with a given letter
SQL
0 vote224 views1 answer
Mysql begin statement
SQL
0 vote198 views1 answer
Raiserror nowait sql server
SQL
0 vote252 views1 answer
Plsql check for string in numeric
SQL
0 vote199 views1 answer
List in one column mysql
SQL
0 vote213 views1 answer
Mysqli_connect using prepare statement
SQL