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 vote191 views1 answer
How to delete duplicate rows in oracle
SQL
15 votes192 views4 answers
Export mysql db using command line
SQL
-1 vote197 views1 answer
Pl sql drop trigger
SQL
8 votes138 views2 answers
Alter column name in mssql
SQL
0 vote186 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote177 views1 answer
Sql grant select only
SQL
12 votes174 views1 answer
How to change the value of a table in sql
SQL
0 vote196 views2 answers
Mysql where in maintain order group_concat
SQL
0 vote187 views1 answer
Reset keys in sql
SQL
5 votes167 views2 answers
Postgre insert select
SQL