17,377
社区成员
发帖
与我相关
我的任务
分享
id shijian
1 20130712
2 20130712
3 20130712
4 20130712
1 20130710
1 20130711
2 20130708
3 20130713
4 20130715
select id from t shijian=20130712
with t as(
select '1' id ,'20130712' shijian from dual
union all
select '2' id, '20130712' shijian from dual
union all
select '3' id, '20130712' shijian from dual
union all
select '4' id, '20130712' shijian from dual
union all
select '1' id, '20130710' shijian from dual
union all
select '1' id, '20130711' shijian from dual
union all
select '2' id, '20130708' shijian from dual
union all
select '3' id, '20130713' shijian from dual
union all
select '4' id, '20130715' shijian from dual),
m as (select id,shijian from t where shijian='20130712')
select id,shijian
from t
where t.id in(select id from m)
and t.shijian<'20130712'
union all
select id,shijian
from m
with t as(
select '1' id ,'20130712' shijian from dual
union all
select '2' id, '20130712' shijian from dual
union all
select '3' id, '20130712' shijian from dual
union all
select '4' id, '20130712' shijian from dual
union all
select '1' id, '20130710' shijian from dual
union all
select '1' id, '20130711' shijian from dual
union all
select '2' id, '20130708' shijian from dual
union all
select '3' id, '20130713' shijian from dual
union all
select '4' id, '20130715' shijian from dual
union all
select '5' id, '20130711' shijian from dual
union all
select '5' id, '20130710' shijian from dual)
select id,shijian
from t
where t.shijian<='20130712';
with t as(
select '1' id ,'20130712' shijian from dual
union all
select '2' id, '20130712' shijian from dual
union all
select '3' id, '20130712' shijian from dual
union all
select '4' id, '20130712' shijian from dual
union all
select '1' id, '20130710' shijian from dual
union all
select '1' id, '20130711' shijian from dual
union all
select '2' id, '20130708' shijian from dual
union all
select '3' id, '20130713' shijian from dual
union all
select '4' id, '20130715' shijian from dual)
select id,shijian
from t
where t.shijian<='20130712';