nth Highest salary
Find the Nth highest salary
Solution: Common logic for all database is as...
select t.name,t.salary from employee t
where N= (
select count(u.salary) from
(select distinct salary from employee ) as u
where t.salary<= u.salary
)
Solution: Common logic for all database is as...
select t.name,t.salary from employee t
where N= (
select count(u.salary) from
(select distinct salary from employee ) as u
where t.salary<= u.salary
)
Comments
Post a Comment