Find out the 3rd highest salary?
- 51 Answers
- 62036 Views
- BirlaSoft, DAC, Silvia Infotech, Sutra Infotech, I also Faced
- E-Mail Answers
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 are the commands used in sql?
What is audit logout in sql profiler?
Is and as keyword in pl sql?
Does a user_objects view have an entry for a trigger?
Why do we need cursor in pl sql?
how to enter numeric values as hex numbers? : Sql dba
What company owns postgresql?
Why is there a need for sqlcode and sqlerrm variables?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
List and explain the different types of join clauses supported in ansi-standard sql?
Does user triggers have entry for trigger with compilation errors?
How to write a query to show the details of a student from students table whose
What are instead of triggers?
What problem one might face while writing log information to a data-base table in pl/sql?
What is synchronized subquery?
