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
Why packages are used in oracle?
Explain what does a control file contain?
what is the difference between data migration and production migration.
What do you mean by group by clause?
How to select some columns from a table in oracle?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
How do you tell what your machine name is and what is its IP address?
Explain a private synonyms?
How does oracle handle read consistency?
What language does oracle use?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
How to grant create session privilege to a user in oracle?
What is a trigger oracle?
Is there any function in oracle similar like group_concat of mysql?
How to view existing locks on the database?