Find out the 3rd highest salary?
Answer Posted / priyanga.g
1) Select MAX(salary) from Programmer where salary not
in(select top 2 salary from Programmer order by salary desc)
2) Select max(salary) from programmer where salary<
(select MAX(salary) from Programmer where salary<(select
MAX(salary) from Programmer))
3) Select MAX(salary) from Programmer e where 2=(select
COUNT(*) from programmer b where b.salary>e.salary )
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is sql open source?
What are % type and % rowtype?
What does fetching a cursor do?
How subquery works in sql?
What is a common use of group by in sql?
Is it possible for a table to have more than one foreign key?
What is a recursive stored procedure?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
What is scalar and vector?
Is it possible to create the following trigger: before or after update trigger for each row?
What is oracle and pl sql?
What is $$ in sql?
What is use of package in pl sql?
What is a table?
What is sharding in sql?