title: GROUP BY tsql, multiple records to return one
body: <p>I have a table as follows:</p>
  
  <pre><code>INSTR_ID    PRC_TMS     PRC_CURR_CDE    PRC_TYP    PRC_QUOTE_AMT
  5901        31/03/2015  EUR             CLO         89.73
  5901        31/03/2015  EUR             LST         89.53
  1123        31/03/2015  USD             CLO         12.35 
  </code></pre>
  
  <p>What I need to be able to do is query a select on this, but where I've got multiple INSTR_ID's, if I have a CLO PRC_TYP then return that PRC_QUOTE_AMT, else the LST PRC_QUOTE_AMT.</p>
  
  <p>I've looked at group by, but unsure of how to build the logic to select CLO else LST?</p>
  
  <p>Can someone point me in the right direction?</p>