17,377
社区成员
发帖
与我相关
我的任务
分享
select ym,dd,num
from tab
where ym = 201107
and DD > 26
union all
select ym,dd,num
from tab
where ym = 201108
and DD < 5
select num
from table_name
where ym||lpad(dd,2,'0') between '20110726' and '20110805';