title: Sorting using both ASC and DESC
body: <p>I have election table, I want to sort the first column in ascending order and last column in descending order but it is not giving desired output.The last column should also be sorted in descending order. This is the query I have used</p>
  
  <pre><code>SELECT *
  FROM election
  WHERE PARTY = 'IND' ORDER BY 'AC_NO' ASC ,'VOTES' DESC
  </code></pre>
  
  <p>thanks in advance</p>
  
  <pre><code>AC_NO  CAND_NO  PARTY  VOTES 
   1       10      IND   240 
   1       11      IND   315 
   1       12      IND   564 
   1       13      IND   1197 
   1       14      IND   1070 
   2        6      IND   782 
   2        8      IND   502
  </code></pre>