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 vote204 views1 answer
Sql find column name like
SQL
-1 vote208 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
4 votes186 views1 answer
Sql any
SQL
0 vote199 views1 answer
Mysql server not running
SQL
9 votes194 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote212 views1 answer
Sql last time database was accessed
SQL
0 vote343 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote187 views1 answer
Exec procedure oracle
SQL
0 vote281 views1 answer
ORA-00942
SQL
0 vote202 views1 answer
Mysqli_connect using prepare statement
SQL