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 vote117 views1 answer
Stored procedure return value
SQL
0 vote106 views2 answers
Postgresql change user role grant
SQL
4 votes96 views3 answers
Copy table postgres
SQL
0 vote111 views1 answer
ALV GRID events
SQL
0 vote107 views1 answer
On update current_timestamp jpa
SQL
1 vote119 views2 answers
Mysql limit offset
SQL
3 votes109 views1 answer
How to check schema privileges in oracle
SQL
0 vote116 views1 answer
Search starting with mysql
SQL
2 votes155 views1 answer
Sql compare strings
SQL
5 votes108 views3 answers
Oracle list columns in schema
SQL