Monday, March 24, 2014

nTH Sallary in MSSql

select e1.Sallary, e1.Customername from TblCustomer e1

where N-1 = (select count(distinct e2.Sallary) from TblCustomer e2 where e1.Sallary< e2.Sallary )

No comments:

Post a Comment