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 vote338 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
0 vote344 views1 answer
Tsql table column constraint must be uppercase
SQL
2 votes333 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
14 votes348 views3 answers
Inner join sql oracle
SQL
0 vote348 views1 answer
ACCEPT nome PROMPT on oracle
SQL
0 vote325 views1 answer
Sql get month and year from date
SQL
0 vote349 views1 answer
Sql declare variable single line
SQL
0 vote360 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
1 vote332 views1 answer
Show all event schedular on mysql
SQL
0 vote371 views1 answer
Change date in pivot table to month in sql server
SQL