回复：SQL菜鸟请教初级+sql问题(类似上题，有些变动)，在线等...

来源: nice2u 于 2009-11-10 14:38:35 [] [旧帖] [给我悄悄话] 阅读数 : (293 bytes)

select min(begdate),enddate

from (

select begdate,
enddate
from sometable
where enddate = (
select max(enddate)
from sometable
)
)
group by
enddate

above will work for Oracle and DB2

请您先登陆，再发跟帖！