select .... from a,(select b,.... from (select b,..,row_number() over(partition by b order by create_date)"row"--create_date:b表b字段创建时间from b ) where "row" =1) b where a.a=b.b上面的......代表你要查的其他字段oracle 可用
