一句sql问题?求解答！

[刘痕]

SELECT LEVEL AS ID FROM DUAL start with level = 2000 CONNECT BY LEVEL < 2011
我想查询这两年中间的年份。求知识，求什么不出来呢。。。。

[刘痕]

select * from (SELECT LEVEL AS ID FROM DUAL CONNECT BY LEVEL < 2011) where id>2000

[tiangtangcao]

[Quote=引用 1 楼 hateson 的回复:]
select * from (SELECT LEVEL AS ID FROM DUAL CONNECT BY LEVEL < 2011) where id>2000
[/Quote]
这样应该能出来了吧

[SKY_4K_PPM]

select 2000 + rownum
from dual
connect by rownum< 2011 - 2000

[draftbeer]

SELECT LEVEL as ID FROM DUAL where level >2000 CONNECT BY LEVEL < 2011