title: sorting max to min value in sql is not working properly
body: <p>i have 1 table for ex table1
  and it have columns names: id, name, amount.</p>
  
  <pre><code>id name amount
  1  abc  20
  2  xyz  50
  3  pqr  246
  </code></pre>
  
  <p>i want to sort it from max value to min.
  i have written this query:</p>
  
  <pre><code>SELECT * FROM table1 ORDER BY amount DESC;
  </code></pre>
  
  <p>but it gives output like this:</p>
  
  <pre><code>id name amount
  2  xyz  50
  3  pqr  246
  1  abc  20
  </code></pre>
  
  <p>which is not valid output that i want, i want output like this:</p>
  
  <pre><code>id name amount
  3  pqr  246
  2  xyz  50
  1  abc  20
  </code></pre>
  
  <p>so, if anyone know the solution of this problem please give me the solution.</p>