Interested to Buy Any Domain ? << Click Here >> for more details...
Find out the 3rd highest salary?
- 51 Answers
- 74274 Views
- BirlaSoft, DAC, Silvia Infotech, Sutra Infotech, I also Faced
- E-Mail Answers
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
How to run sql commands in sql*plus?
What does trigger mean in psychology?
Does view contain data?
how many tables will create when we create table, what are they? : Sql dba
Why is there a need for sqlcode and sqlerrm variables?
How to select all records from the table?
What is sql resultset?
what is a control file ? : Sql dba
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
How do I know if I have sql express or standard?
what is a table in a database ? : Sql dba
what is the use of double ampersand (&&) in sql queries?
What is attribute indicator in pl sql?
How subquery works in sql?
how to use like conditions? : Sql dba
