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 vote145 views1 answer
Does insert into overwrite sql
SQL
2 votes216 views1 answer
Oracle list grants on package
SQL
13 votes129 views6 answers
Current date sql
SQL
2 votes126 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote142 views1 answer
Power query datetime to date
SQL
2 votes139 views1 answer
Oracle sql drop column if exists
SQL
5 votes153 views4 answers
Start postgres server
SQL
0 vote165 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote131 views1 answer
IIF
SQL
0 vote135 views1 answer
Grant privileges of databse to user
SQL