title: Filter duplicate records and join them in other records - ORACLE
body: <p><a href="https://i.stack.imgur.com/mFxfT.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mFxfT.jpg" alt="enter image description here"></a></p>
  
  <p>I want to filter duplicate the 'PDLINEGROUP' value,and then making them join in other records(Require:date is latest).</p>
  
  <p>THANKS IN ADVANCE.</p>