1.闭区间查询,且不破坏索引
select * from withdrawworkorder_bak where requestdate>=to_date('2012-08-01','yyyy-MM-dd') and requestdate<to_date('2012-08-31','yyyy-MM-dd')+1;
1.闭区间查询,且不破坏索引
select * from withdrawworkorder_bak where requestdate>=to_date('2012-08-01','yyyy-MM-dd') and requestdate<to_date('2012-08-31','yyyy-MM-dd')+1;