title: SQL query interleaving two different statuses
body: <p>I have a table testtable having fields</p>
  
  <pre><code>Id    Name       Status
  1     John       active
  2     adam       active
  3     cristy    incative
  4     benjamin  inactive
  5     mathew    active
  6     thomas    inactive
  7     james     active
  </code></pre>
  
  <p>I want a query that should dispaly the reuslt like</p>
  
  <pre><code>Id    Name       Status
  
  1     John       active
  3     cristy    incative
  2     adam       active
  4     benjamin  inactive
  5     mathew    active
  6     thomas    inactive
  7     james     active
  </code></pre>
  
  <p>my question is how to take records in the order of active status then inactive then active then inactive etc.. like that from this table.</p>