find out the second highest salary?
Answer Posted / nagaraju
SELECT LEVEL,MAX(SAL)
FROM EMP
WHERE LEVEL IN(2,3)
CONNECT BY PRIOR SAL>SAL
GROUP BY LEVEL;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is ADDM Advisor in Oracle?
Is rowid unique in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
What are the original export and import utilities?
How to create a stored procedure in oracle?
Describe varray?
Can you tell me how to add new column in existing views?how?How is possible?
What are temporal data types in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What are a query and state the different types of queries and their uses?
What is a directory object?
What is Library Cache in Oracle?
What is an index associated with a constraint?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What is a relational database management system?