find out the third highest salary?
Answer Posted / sapna rawal
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC)
ORDER BY salary ;
n=3.In this case.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
How do I uninstall oracle 11g?
What are the various constraints used in oracle?
What is oracle used for?
How to Truncate Table in Oracle
interview questions with answer for cts
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
Why do you use stored procedures and state some of its disadvantages?
Explain about achiever in sql?
How to convert characters to numbers in oracle?
What are the different types of synonyms?
What is an oracle transaction?
What is oracle server autotrace in oracle?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
List out the components of logical database structure of oracle database.
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?