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 vote203 views1 answer
Mysql select distinct date from timestamp
SQL
16 votes233 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
1 vote215 views1 answer
Error code 1055
SQL
0 vote246 views1 answer
Select distinct after join
SQL
0 vote222 views1 answer
Flush user resource mysql
SQL
0 vote225 views1 answer
Varchar2 length in oracle
SQL
0 vote227 views1 answer
MySQL update with subquery
SQL
0 vote227 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote255 views1 answer
Sql create and grant user access to database
SQL
3 votes206 views1 answer
How to remove characters from string in mysql
SQL