Query to get max and second max in oracle in one query ?
- 34 Answers
- 57374 Views
- CTS, Keane India Ltd, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / samir kumar sahoo
SELECT sal FROM(SELECT DISTINCT(sal) FROM employees ORDER
BY sal DESC) WHERE ROWNUM<=2;
| Is This Answer Correct ? | 23 Yes | 2 No |
Post New Answer View All Answers
Explain an extent?
How do you tell what your machine name is and what is its IP address?
Explain the use of record option in exp command.
How can I see all tables in oracle?
How does oracle handle read consistency?
What is an oracle?
How to display row numbers with the records?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How to increment dates by 1 in oracle?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
Explain the use of consistent option in exp command.
What is oracle in java?
What is a proxy object?
Explain the difference between sap and oracle?
Where do we use decode and case statements?
