如何选择时间段查询数据

Question

select * from 表 where year='2005' and month<='12';

Answer 1

select * from table where year||to_char(to_number(month),'09')>='200501' and year||to_char(to_number(month),'09')<='200510';

Answer 2

select * from 表 where trim(year)='2005' and trim(month)<='11';

Answer 3

谢谢楼上各位我写出来了,如下:
select * from 表 where year||decode(length(month),2,month,'0'||month)>='200501' and
 year||decode(length(month),2,month,'0'||month)<='200511' ;

Answer 4

select * from 表 where year||decode(length(month),2,month,'0'||month)>='200501' and
 year||decode(length(month),2,month,'0'||month)<='200511' ;