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

What is meaning of <> in sql?

1129

What are pl/sql packages?

1158

What is update query?

1033

What are tables in sql?

1116

what is 'mysqladmin' in mysql? : Sql dba

1074

How to pipe multiline string to isql?

1050

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

1055

What are the types pl/sql code blocks?

1196

What is sqlcontext?

1147

What is sql partition function?

1290

Is it mandatory for the primary key to be given a value when a new record is inserted?

1252

What are crud methods?

1086

What is trigger types of trigger?

1144

Is sql low level language?

1066

What is a subquery in sql?

1090