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
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What is partitioned table in Oracle?
What is a sub query and what are the different types of subqueries?
Explain self joins in oracle?
How to use subqueries with the in operator using oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
What is a synonym? What are its various types?
Difference between hot backup vs. Cold backup?
How to define a data source name (dsn) in odbc manager?
How oracle handles dead locks?
How to compare dates in oracle sql?
How to start a new transaction in oracle?
Explain what are the characteristics of data files?
What to do if the startbd.bat failed to start the xe instance?
What is the difference between PFILE and SPFILE in Oracle?