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 vote381 views2 answers
Logical operators in sql
SQL
1 vote309 views1 answer
Postgres reset auto increment
SQL
0 vote357 views1 answer
Alter table myisam to innodb
SQL
0 vote374 views1 answer
Mysql shell ERROR: Not connected.
SQL
7 votes348 views1 answer
Forge server hosting
SQL
1 vote352 views1 answer
Increase existing date in sql oracle
SQL
14 votes368 views3 answers
Oracle sql limit results
SQL
0 vote357 views1 answer
Varchar format not case sensitive sql
SQL
1 vote347 views1 answer
Import in mysql without a software
SQL
0 vote349 views1 answer
Update if else mysql
SQL