title: select second 50% of a table
body: <p>I want to select <strong>second 50%</strong> of a table <strong>I mean 50% to 100%</strong> , not this :</p>
  
  <p>Select top (50) percent *
  from Production.Product  -- this gave me the first 50% of Table</p>
  
  <p><em>and i don't have a specific column for counting rows and i need to use top , count, etc , please help me write the code</em></p>
  
  <p><strong>I'm using Microsoft SQL server</strong></p>