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 vote341 views1 answer
Sample in sql
SQL
0 vote347 views1 answer
No suitable driver found for sqlite
SQL
1 vote322 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote377 views1 answer
Gcloud sql instance list
SQL
0 vote330 views1 answer
Oracle search in date columns
SQL
3 votes352 views1 answer
Créer une table sql
SQL
8 votes345 views2 answers
Change name of colum in sql table
SQL
1 vote327 views1 answer
Index a database column sql
SQL
1 vote340 views1 answer
How to find median of a column sql
SQL
0 vote363 views1 answer
Last date for each user sql
SQL