SELECT MAX(Sal) FROM Emp WHERE Level=&Levelno ORDER BY PRIOR Sal

Write a query to find second highest salary of an employee.

Question Posted / murali

Answer Posted / murali

SELECT
MAX(Sal)
FROM
Emp
WHERE
Level=&Levelno
ORDER BY PRIOR Sal>Sal
GROUP BY Level

--Here we have to give &Levelno = 2

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How can triggers be used for the table auditing?

1078

What is nosql example?

1041

what is the difference between clustered and non clustered index in sql? : Sql dba

1134

what is a join? : Sql dba

1047

What is %type in sql?

973

What is schema in sql example?

1192

what are myisam tables? : Sql dba

1042

Does user triggers have entry for trigger with compilation errors?

1045

What are the parameter modes supported by pl/sql?

1118

What is difference between ms sql and mysql?

976

Why is sql*loader direct path so fast?

1114

What is spool?

1062

what is a relationship and what are they? : Sql dba

1112

Why do we use joins in sql?

977

What can I use instead of union in sql?

977