title: Select top 10 percent, also bottom percent in SQL Server
body: <p>I have two questions:</p>
  
  <ol>
  <li><p>When using the <code>select top 10 percent</code> statement, for example on a test database with 100 scores, like this:</p>
  
  <pre><code>Select top 10 percent score 
  from test
  </code></pre>
  
  <p>Would SQL Server return the 10 highest scores, or just the top 10 obs based on how the data look like now (e.g. if the data is entered into database in a way that lowest score appears first, then would this return the lowest 10 scores)?</p></li>
  <li><p>I want to be able to get the top 10 highest scores and bottom 10 lowest scores out of this 100 scores, what should I do? </p></li>
  </ol>