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 vote142 views1 answer
Limiting query result using where in sql
SQL
1 vote161 views1 answer
Sqlserver create table from select
SQL
0 vote149 views1 answer
Insufficient memory to excute the sql query
SQL
0 vote171 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote160 views1 answer
Sql find table by name
SQL
-1 vote144 views1 answer
Search all database tables for a value sqlserver
SQL
2 votes200 views3 answers
Mysql kill
SQL
0 vote169 views1 answer
Cube oracle
SQL
0 vote154 views1 answer
How to list function in psql
SQL
2 votes174 views3 answers
Oracle show column of table
SQL