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

3 votes98 views2 answers
Postgres inner join vs join
SQL
0 vote108 views1 answer
Convert polygon to text in mysql
SQL
0 vote54 views1 answer
How to connect sql server using ip address in c#
SQL
3 votes116 views1 answer
Export postgres database linux
SQL
0 vote113 views1 answer
Mysql remove bad character from all fields
SQL
2 votes108 views2 answers
Postgresql get table names
SQL
0 vote114 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote125 views3 answers
Constraint sql
SQL
16 votes105 views3 answers
Jwt secret key generator laravel
SQL
150 votes258 views10 answers
Grepper
SQL