Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 65218 Views
- CTS, Keane India Ltd, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / roopa
SELECT MAX(E1.sal), MAX(E2.sal)
FROM emp E1, (SELECT sal FROM emp
WHERE sal NOT IN ( SELECT MAX(sal) FROM emp)) E2
| Is This Answer Correct ? | 7 Yes | 7 No |
Post New Answer View All Answers
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
What is Java Pool in Oracle?
What is a sub query? Describe its types?
Point the difference between translate and replace?
What are data pump export and import modes?
Can multiple columns be used in group by in oracle?
Hi Can any one tell me what are the API's used in requisition import.
what is the difference between restoring and recovering?
What happens to the indexes if a table is recovered?
Can you have more than one content canvas view attached with a window ?
How to connect to oracle using service name instead of sid?
What is bulk collect in oracle?
Query to retrieve record for a many to many relationship ?
What operating systems are supported by oracle database 10g xe?
material view and view disadvantages?
