Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / naresh
Here it is the simple solution.
Select Salary from (Select Salary, Rownum from Employee
order by Salary desc) where rownum=2
Should Work
Cheers!
Naresh
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is a Nested Loop join?
Give the various exception types.
How to start an oracle instance?
What is oracle used for?
How to execute a stored procedure in oracle?
How to rename an index?
What is a Garbage Collection? and what is full recursive Garbage collection?
What do you mean by redo log file mirroring?
How to display row numbers with the records?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What happens if variable names collide with table/column names?
How does Oracle guarantee data integrity of data changes?
What is an index associated with a constraint?
How do I connect to oracle database?
What is the difference between alert log file and tarce file ?
