Write a query to find second highest salary of an employee.
- 27 Answers
- 21975 Views
- I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What are all types of user defined functions?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
Explain what is dbms?
How to take user input in pl sql?
What is nosql vs sql?
What is rank dense_rank and partition in sql?
How do I sort a table in sql?
what is union, minus and interact commands? : Sql dba
What is nested table in pl sql?
Why truncate is faster than delete?
How can you create an empty table from an existing table?
what is the difference between delete and truncate statement in sql? : Sql dba
What are crud methods?
What is a ddl command?
What is sql*plus?
