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 )