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 many sectors are in a partition?

1028

How do I find duplicates in sql?

873

What is the difference between a subquery and a join?

1010

How would you convert date into julian date format?

946

What is the life of an sql statement?

960

What are its different types of dbms?

955

What schema means?

843

What is the largest value that can be stored in a byte data field?

955

How to run sql functions in pl/sql?

987

what is the difference between $message and $$message? : Sql dba

941

Is json a nosql?

914

Is inner join same as self join?

1059

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

906

How to write pl sql program in mysql command prompt?

1006

What is a sql driver?

939