oracle 一个表里有多条记录引用另一个表的主键 并获取此表的最后一条记录

表1：

表2：

现在要获得repid=48   对应表2的最后一天记录，也就是要查处dealid=58

SQL:

select *
          from mgruserrepresentationsdeal md
         where md.dealid = (select max(dealid) dealid
                              from mgruserrepresentationsdeal tp
                             where tp.repid ='48')

结果：

现在要获得表1里每个repid对应表2的记录并取最后条数据

SQL：

select *

  from MGRUSERREPRESENTATIONS mr,
       (select *
          from mgruserrepresentationsdeal md
         where md.dealid = (select max(dealid) dealid
                              from mgruserrepresentationsdeal tp
                             where tp.repid = md.repid)) m

 where mr.repid = m.repid

结果：