하기 쿼리 참고하세요

---쿼리시작---

;with tblA(prod,netprice,unit,unit2,reg_date) As
(
      Select 'a',189.15  ,'USD','PC','20120101' From dual Union All
      Select 'a',184617  ,'KRW','PC','20150223' From dual Union All
      Select 'a',235256  ,'KRW','PC','20130117' From dual Union All
      Select 'a',901182  ,'KRW','PC','20131226' From dual Union All
      Select 'a',1083824 ,'KRW','PC','20130115' From dual
)
      Select a.*
        From (
                 Select a.prod
                       ,a.netprice
                       ,a.unit
                       ,a.unit2
                       ,a.reg_date
                       ,Row_Number() Over (Partition By a.prod,a.unit Order By a.reg_date Desc) As rn
                   From tblA a
             ) a
       Where a.rn = 1
---쿼리끝---      

대박 사건 !!!!!

한영님......... 감사 드려욤... ^^;;

염치 없지만, 좋은 정보 공유 감사 드립니당....

앞으로 열심히 해야 겠네욤...

복 많이 받으세욤... ^^