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 vote145 views1 answer
Oracle job session
SQL
0 vote128 views1 answer
Psql list view rules
SQL
2 votes117 views1 answer
Sql like variable
SQL
-1 vote154 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote130 views1 answer
Mysql add text to existing field
SQL
0 vote141 views1 answer
Show table structure mysql console
SQL
0 vote137 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote123 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote137 views1 answer
Sql convert float to string
SQL
3 votes136 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL