How to Select second Maximum salary in a Table ?
Answer Posted / sephali
select sal, rownum
from (select sal from table
order by sal desc)
where rownum=2
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to write a left outer join with the where clause in oracle?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What is Segment Advisor in Oracle?
what is the use of system.effective.date variable in oracle?
How to rename an index in oracle?
What are the components of logical database structure in oracle database?
What is materialized view in Oracle?
What is redo log?
 What are the oracle DML commands possible through an update strategy?
How to write text literals in oracle?
what happened to the global index when I truncate the data in one of the partition?
why dont we assign not null constraint as table level constraint.
Explain coalesce function?