title: how to find Distinct data from database when foreign key is duplicated
body: <pre><code>Candidate_ID IsProccesd?
          22             1
          22             0
  </code></pre>
  
  <p><strong>OUTPUT</strong> :None</p>
  
  <pre><code>Candidate_ID IsProccesd?
          22             0
          22             0
  </code></pre>
  
  <p><strong>OUTPUT</strong>: Record Deleted</p>
  
  <p>i want to Query for this data</p>