title: MySQL set with where condition
body: <p>Please tell me how to apply this query.</p>
  
  <p>I want to set <code>first position</code> in <code>remarks</code>, where student <code>sgpa</code> is the highest.</p>
  
  <p>I've tried the following:</p>
  
  <pre><code>update mcs1 
  set remarks = "First position" 
  where sgpa = top 1 
  order by sgpa asc
  </code></pre>