50 percentage select record from table

 (1).select top 50 percentage from employee

(2).Public delegate void delegatename(); ye hamesh namespace ke uper likhate hain.

(3)  ;with resulte  as

(

select salary dense_rank() over(order by  salary desc) as densRank from employee

)

select top 1 salary from result where densRank=1;