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 vote140 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote189 views1 answer
Psql check table fields
SQL
1 vote150 views1 answer
Show indices in mysql table
SQL
25 votes172 views3 answers
How to use a database to see tables mysql
SQL
8 votes180 views2 answers
Safe update mode in mysql
SQL
1 vote157 views1 answer
Median mysql
SQL
0 vote161 views1 answer
Postgresql where clause not working
SQL
0 vote132 views1 answer
Delete all rows from table sqlite
SQL
0 vote171 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
1 vote160 views1 answer
Find a column in all tables postgres
SQL