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 the file extension for sql database?
Explain the difference between 'between' & 'and' operators in sql
What are the two virtual tables available at the time of database trigger execution?
What is a common use of group by in sql?
What are the different parts of a package?
What are expressions?
Does sql support programming?
what is the command used to fetch first 5 characters of the string? : Sql dba
what is the difference between join and union? : Sql dba
Does sql*plus also have a pl/sql engine?
Difference between table function and pipelined function?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is sql performance tuning?
How to look at the current sql*plus system settings?
What are inner and outer joins examples of both?