find out the third highest salary?
Answer Posted / mihir nasikkar
Here n is 3
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is an anonymous block?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What is oracle host variable?
How is it different from a normal table?
How to recover a dropped table in oracle?
What happens to the indexes if a table is recovered?
Explain the use of online redo log files in oracle.
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How do I uninstall oracle client from windows?
How to handle a single quote in oracle sql?
What are the uses of synonyms?
How to delete a column in an existing table in oracle?
How many types of cluster table in Oracle?
How to loop through a cursor variable?
How to create an oracle testing table?