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;