I am trying to make selection of top 30% and bottom 70% ordered results in a table.
I am using :
select top (30)percent from table 1
(70)percent from table 1 order by desc
Problem is that if the record has same values for that ordered column then I might pick the same record twice.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?