select e1.Sallary, e1.Customername from TblCustomer e1
where N-1 = (select count(distinct e2.Sallary) from TblCustomer e2 where e1.Sallary< e2.Sallary )
where N-1 = (select count(distinct e2.Sallary) from TblCustomer e2 where e1.Sallary< e2.Sallary )
No comments:
Post a Comment