Find out the 3rd highest salary?
Answer Posted / himanshu
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between an inner join and an outer join?
What is the difference between null value, zero, and blank space?
Does sql between include endpoints?
what are the types of subquery? : Sql dba
What is schema in sql example?
Is left join same as join?
How do I find sql profiler?
Explain what is rdbms?
Is record in oracle pl sql?
What are sql queries used for?
Why is nosql good?
what is the difference between cluster and non cluster index? : Sql dba
What are the different types of a subquery?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What is pl sql package?