title: SQL Find first occurrence of row in table
body: <pre><code>id name marks 
  1;"mohit";10
  2;"mohit";20
  3;"raj";30
  4;"rupesh";40
  5;"rupesh";50
  </code></pre>
  
  <p>Expected output is :</p>
  
  <pre><code>1;"mohit";10
  4;"rupesh";40
  </code></pre>