What will be easier way to group records by range of percents.
Here what I try to accomplish
Select top percents between 50 and 75 * from myTable order by PKI
Here is way I did this but I have felling that it cloud be much much easier
select top(25) percent * from myTable where id not in ( select top(25) percent ID from myTable order by PKI ) order by PKI
This should be top 50 - 75 percents of my table ?
Is there better (nicer) way to do this.