How to Select second Maximum salary in a Table ?
- 13 Answers
- 13545 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / sunil
select max(sal) from table_name where
sal<(select max(sal) from table_name);
or
select sal from(select sal,dense_rank() over(order by sal)
as rnk from table_name) where rnk=2;
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
How can I combine multiple rows into a comma-delimited list in oracle?
What is a tns file?
Why use resource manager in Oracle?
How to start an oracle instance?
Explain an integrity constrains?
What is object data modeling?
What is the difference between substr & instr functions?
What are the numeric comparison operations?
what is the difference between restoring and recovering?
1) Does oracle have any table which contain all the exceptions and it's code internally?
Explain the use of record option in exp command.
How will you identify oracle database software release?
Describe varray?
What is tns service name?
What is a static data dictionary in oracle?
