title: How do we select top 20% and bottom 80% records in sql server
body: <p>I am trying to select the top 20% ordered results and also remaining (bottom 80%) in a table.</p>
  
  <p>when I do </p>
  
  <pre><code>select top (20)percent from table 1
  </code></pre>
  
  <p>and later </p>
  
  <pre><code>select top (80)percent from table 1 order by desc
  </code></pre>
  
  <p>as two different queries, I get the result. But my problem here is, if the record has the same values for the ordered column, then I might pick the same record again, as the selection is not content. </p>
  
  <p>Can you suggest with any good way so that I can select the top 20% distinctly and remaining 80% records in a table?</p>