Find out the 3rd highest salary?
Answer Posted / abhijt shinde
select MIN(salary) from Employees
where salary IN
(Select Top 3 salary from Employees order by salary desc)
Select Top 1 salary from Employees where salary
Not IN(select Top 1 salary from Employees order by salary Desc)
order by salary Desc
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is primary key and foreign key?
Can we use ddl statements in stored procedure?
How do I restart sql?
What is package in pl sql?
Why schema is used in sql?
What are the properties of a transaction?
Write a query to display the current date in sql?
What are sql built in functions?
List the different type of joins?
How to run pl/sql statements in sql*plus?
Is sql harder than python?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
How do you go back in sql?
What is a full join sql?
What is a procedure in pl sql?