title: Selecting a complete group of records from other groups based on one row condition
body: <p>There is a group of rows which have the losscode and service odom. The contract number and service odometer are used to group the rows.</p>
  
  <p>help me to find the way to select only the row group which have the losscode = 'REVSTD'?</p>
  
  <p><a href="https://i.stack.imgur.com/13Ts5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/13Ts5.png" alt="enter image description here"></a></p>
  
  <p>Thanks in advance</p>