title: SQL 'order by' first, and then next
body: <p>I have a table, something like</p>
  <pre><code>STUDENTNAME   ISMANUALLYADDED   ISEDITED
  -----------   ---------------   --------
  APPLE              0               0
  ANT                0               1
  BELL               0               0
  DOLL               1               0
  </code></pre>
  <p>Here, I am trying to sort the data by <code>studentname</code> first, by <code>ismanuallyadded</code>, and then by <code>isedited</code>. I am expecting the result like:</p>
  <pre><code>StudentName
  -----------
  APPLE
  BELL
  DOLL
  ANT
  </code></pre>
  <p>For this, I am trying like,</p>
  <pre><code>select studentname from table1
  order by studentname, ismanuallyadded, isedited
  </code></pre>
  <p>but, this query gives the result like,</p>
  <pre><code>Student
  -------
  APPLE
  ANT
  BELL
  DOLL
  </code></pre>
  <p>Is it possible to order by <code>studentname</code> first and then order by <code>ismanuallyadded</code>?</p>
  <p>I am trying to display all the studentnames (neither <code>manually added</code> nor <code>isedited</code>) alphabetically, then only <code>ismanuallyadded</code> students should come, and then <code>isedited</code>.</p>