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 vote141 views1 answer
Oracle sql first day of year
SQL
0 vote144 views1 answer
What logs are available on RDS MySQL?
SQL
7 votes127 views4 answers
Lowest salary in sql
SQL
1 vote150 views1 answer
Tsql create unique index composite
SQL
3 votes136 views1 answer
Fk in insert mysql
SQL
0 vote158 views1 answer
Varchar2 length in oracle
SQL
0 vote127 views1 answer
C# mysql update statement set value to null
SQL
8 votes127 views1 answer
Ltrim sql
SQL
5 votes128 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote135 views1 answer
Database schema for mcqs type exam in sql
SQL