副問合せは好きではありませんが、sqlなら次のような感じです
select mbr.member_id, mbr.ip_addr , mbr.regist_date from mbr_history mbr where mbr.regist_date = (select max(mbr2.regist_date) FROM mbr_history mbr2 where mbr.member_id=mbr2.member_id) order by mbr.member_id
副問合せは好きではありませんが、sqlなら次のような感じです
select mbr.member_id, mbr.ip_addr , mbr.regist_date from mbr_history mbr where mbr.regist_date = (select max(mbr2.regist_date) FROM mbr_history mbr2 where mbr.member_id=mbr2.member_id) order by mbr.member_id