title: how to find max value from multiple columns MySQL
body: <p><img src="https://i.stack.imgur.com/3Vljl.png" alt="could`t create table here so had to printscreen "></p>
  
  <p>So the question is how can i show the Supplier (S) that has the maximum quantity (QTY) from table SP.</p>
  
  <p>This is what i came up with:</p>
  
  <pre><code>  SELECT sno FROM sp WHERE sno in (SELECT max(QTY) FROM sp WHERE qty);
  </code></pre>
  
  <p>but it is showing only empty field, and i cannot find the problem.
  I would really appreciate your help.</p>