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 vote166 views1 answer
Mysql convert charset
SQL
51 votes570 views6 answers
Installing mysql on ubuntu
SQL
0 vote168 views1 answer
How to order result of subquery in select
SQL
0 vote167 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote165 views1 answer
Mariadb LOAD DATA INFILE
SQL
4 votes131 views2 answers
Create table if not exists postgres
SQL
6 votes219 views1 answer
Identify primary key in oracle table
SQL
4 votes170 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
2 votes243 views1 answer
Create mysql user on all hosts
SQL
7 votes167 views2 answers
Show size database mysql
SQL