Find out the 3rd highest salary?
Answer Posted / umesh naik
select max(amount) from (
select distinct amount from temp123
where rownum <= 3
)
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
What do you mean by rowid?
How can you fetch common records from two tables?
What are the uses of sysdate and user keywords?
Why do we create stored procedures & functions in pl/sql and how are they different?
What is pl sql record in oracle?
What is record data type?
What are basic techniques of indexing?
What is the difference between mdf and ndf files?
What are the methods of filing?
Why do we use procedures?
What is normalization sql?
Can we join tables without foreign key?
Is like operator in sql case sensitive?
What is the difference between delete and truncate statement in sql?
What is latest version of sql?