find out the third highest salary?
Answer Posted / mohd. rashid
SELECT TOP 1 salary
FROM(
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC)
ORDER BY salary
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between hot backup and cold backup in oracle?
How to convert character types to numeric types?
How many types of segments in Oracle?
What is the usage of analyze command in oracle?
What is backup in Oracle?
Explain the use of show option in imp command.
What is define in oracle?
What is java oracle used for?
What is an oracle user role?
What is the use of oracle?
How to use "while" statements in oracle?
What are the differences between char and varchar2 in oracle?
What is oracle rownum?
How to select some columns from a table in oracle?
What is an external table?