title: SQL How to select Max 5 values from table?
body: <p>In my database I have two tables  and want to select highest 5 values from table but I only get first highest value cannot get more than one value.</p>
  
  <p>Here is my SQL,</p>
  
  <pre><code>SELECT * FROM table1 WHERE id=(SELECT id, MAX(num1+num2) FROM table2 limit 5)
  </code></pre>
  
  <p>How can I get first top 5 highest values?</p>
  
  <p>Thanks.</p>