17,377
社区成员
发帖
与我相关
我的任务
分享
-- 这问题真有趣..
SELECT DISTINCT GOODS_CODE
FROM T1MM11_GOODS_CODE
WHERE ORDER_EFFECT_DATE < '2008/12/19'
AND DEL_FLG = '0';
[Quote=引用楼主 spland 的帖子:]select T1.GOODS_CODE
from T1MM11_GOODS_CODE T1
where ORDER_EFFECT_DATE=
(select Max(ORDER_EFFECT_DATE) as ORDER_EFFECT_DATE
from T1MM11_GOODS_CODE T2
Where ORDER_EFFECT_DATE <'2008/12/19'
AND T1.GOODS_CODE=T2.GOODS_CODE
--group by GOODS_CODE 这个group by 加在这干嘛呢,多余
)
and T1.DEL_FLG='0'
select *
from T1MM11_GOODS_CODE a
where not exists(select 1 from T1MM11_GOODS_CODE where ORDER_EFFECT_DATE=a.ORDER_EFFECT_DATE and ORDER_EFFECT_DATE>a.ORDER_EFFECT_DATE)
select GOODS_CODE
from (select GOODS_CODE,
row_number() over(partition by GOODS_CODE order by ORDER_EFFECT_DATE desc) rn
from T1MM11_GOODS_CODE
Where ORDER_EFFECT_DATE < '2008/12/19'
and DEL_FLG = '0')
where rn = 1
select GOODS_CODE
from (select GOODS_CODE,
row_number() over(partition by GOODS_CODE order by ORDER_EFFECT_DATE desc) rn
from T1MM11_GOODS_CODE
Where ORDER_EFFECT_DATE < '2008/12/19'
and T1.DEL_FLG = '0')
where rn = 1
select GOODS_CODE
from (select GOODS_CODE,
row_number() over(partition by GOODS_CODE order by ORDER_EFFECT_DATE desc from T1MM11_GOODS_CODE) rn
Where ORDER_EFFECT_DATE < '2008/12/19'
and T1.DEL_FLG = '0')
where rn = 1
select *
from
(select *
from T1MM11_GOODS_CODE
where ORDER_EFFECT_DATE <'2008/12/19'
order by ORDER_EFFECT_DATE desc)
where rownum=1