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 bitemporal narrowing?
Name the different types of indexes in sql and define them.
How would you convert date into julian date format?
how to include character strings in sql statements? : Sql dba
What is dense_rank in sql?
How to execute a stored procedure?
How do I run a sql trace?
what is heap table? : Sql dba
Is primary key always clustered index?
What is difference between inner join and self join?
What is the usage of the distinct keyword?
What is duration in sql profiler trace?
what tools available for managing mysql server? : Sql dba
What is a clob in sql?
What are the advantages of pl sql over sql?