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
What is tns entry?
What is truncate oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How many file formats are supported to export data?
What happens to the current transaction if the session is ended?
How many types of segments in Oracle?
What is a trace file and how is it created in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
How to delete a column in an existing table in oracle?
How would you begin to troubleshoot an ORA-3113 error?
Can group functions be mixed with non-group selection fields?
What is system tablespace?
What is the relation of a user account and a schema in oracle?
Explain the use of owner option in exp command.