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
Drop view in mysql
SQL
2 votes135 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote122 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote144 views1 answer
Sql convert float to string
SQL
0 vote150 views1 answer
How to insert same table data using mysql query
SQL
8 votes138 views1 answer
Declare table variable sql server
SQL
3 votes137 views1 answer
Null sql
SQL
0 vote131 views1 answer
Grant privileges of databse to user
SQL
4 votes141 views1 answer
Mysql biginteger size
SQL
0 vote136 views1 answer
Sql find record cannot cast date
SQL