Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 65559 Views
- CTS, Keane India Ltd, TCS, Wipro, I also Faced
- E-Mail Answers
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 are the differences between number and binary_float in oracle?
How to assign values to data fields in record variables?
How to use fetch statement in a loop?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is the use of aggregate functions in oracle?
How to use "if" statements on multiple conditions?
What happens if you use a wrong connect identifier?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
Explain what are the characteristics of data files?
What is coalesce function?
How to rollback the current transaction in oracle?
What is memory advisor in Oracle?
Is the After report trigger fired if the report execution fails ?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What is catalog in Oracle?
