title: Delete multiple occurrences of the same ID # and code in a junction table
body: <p><code>enter code here</code><img src="https://i.stack.imgur.com/zLxhv.jpg" alt="enter image description here"></p>
  
  <p>My problem is this: in this database the junction table contains some rows where the kha_id and the icd_fk are the same.  While it's OK that kha_id appears in icd_junction more than once , it has to be with a separate icd_fk.  I can run a query and get all of the ID#s and the codes which are listed more than once, but is there an industry-standard way of going about deleting all but one occurrence of each?</p>
  
  <p>example: what i have is above</p>
  
  <pre><code>KHA_ID: 123456  V23 
          123456  V23
          123456  V24
  
  I need one of the rows kha_id=123456 and ICD_FK=V23 taken out.
  </code></pre>