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 vote123 views1 answer
Laravel eloquent get generated sql
SQL
2 votes124 views1 answer
Metasploit start postgresql
SQL
0 vote123 views1 answer
Create database store
SQL
0 vote116 views2 answers
Auto increment column in mysql query results
SQL
1 vote117 views3 answers
Mysql connection string
SQL
1 vote113 views1 answer
Apex ORA-20999
SQL
0 vote196 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
5 votes115 views3 answers
Day of week postgresql
SQL
0 vote108 views1 answer
Add plugins to mysql workbench
SQL
0 vote121 views2 answers
Mysql calcular idade
SQL