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 vote96 views1 answer
Where in clause tsql
SQL
5 votes109 views3 answers
Mysql remove unique constraint
SQL
2 votes117 views1 answer
Mysql select default if null
SQL
0 vote99 views1 answer
Sql select rows with different values in one column
SQL
16 votes101 views2 answers
Sql exists
SQL
0 vote114 views1 answer
Mysql terminal run sql file
SQL
0 vote88 views1 answer
CREATE MULTIPLE FK
SQL
0 vote107 views1 answer
Min salary in sql
SQL
0 vote140 views1 answer
Do you know sql
SQL
0 vote58 views1 answer
Mysqli or pdo
SQL