Query to get max and second max in oracle in one query ?
Answer Posted / deepa
select salary from (select salary from table_name order by salary desc) where rownum<3;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
In oracle there is column command, how will you explain that?
What is the difference between "as" and "is" in an oracle stored procedure?
What is user managed backup in Oracle?
What is an oracle transaction?
What is define in oracle?
What is transaction control statement and how many types of transaction control statement in Oracle?
How to change program global area (pga) in oracle?
What is archive log in Oracle?
How to bring a tablespace online?
How to assign data of the deleted row to variables?
Explain what are synonyms used for?
What is a dynamic performance view in oracle?
How to connect to oracle using service name instead of sid?
How to create tables for odbc connection testing?
How to convert a string to a date in oracle database?