with tab as (
select ‘2001’ d from dual union all
select ‘2002’ d from dual union all
select ‘2003’ d from dual union all
select ‘2006’ d from dual union all
select ‘2007’ d from dual union all
select ‘2008’ d from dual)
SELECT SS
FROM (SELECT SN + (level - 1) SS
FROM (select min(d) SN,max(d) EN from tab) T
CONNECT BY SN + (level - 1) <= EN)
WHERE SS NOT IN (SELECT d FROM tab)
oracle 查询缺失数据
最新推荐文章于 2022-11-29 14:00:10 发布