title: How can I get the bottom 50% of a select query in SQL server?
body: <p>In SQL server I can say:</p>
  
  <pre><code>Select top 50 percent
  </code></pre>
  
  <p>How can I say bottom 50 percent?</p>
  
  <p>EDIT - for the sake of an interesting question, if we assume he has a table with a primary key but wants the bottom 50% ordered in <strong>ascending</strong> primary key order. What would be the most efficient way of achieving that?</p>