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

19 votes206 views6 answers
Sql server drop table if exists
SQL
3 votes202 views1 answer
Select sequence oracle
SQL
0 vote195 views1 answer
Get current date data in mysql
SQL
0 vote209 views2 answers
Update query with between in mysql
SQL
0 vote189 views1 answer
Sql create table with datetime automatically
SQL
0 vote193 views2 answers
T SQl Checking Your Username
SQL
0 vote187 views1 answer
Exec procedure oracle
SQL
0 vote258 views1 answer
Sql decimal to 2 places
SQL
0 vote212 views1 answer
Mysql get nth highest
SQL
20 votes233 views4 answers
How to find average in sql
SQL