how to find the second highest salary from emp table?
Answer Posted / jithu
SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN
(SELECT MAX(SALARY) FROM EMPLOYEE)
| Is This Answer Correct ? | 9 Yes | 8 No |
Post New Answer View All Answers
What is bulk collect in pl sql?
Name the operator which is used in the query for pattern matching?
What are the benefits of pl/sql packages?
what are the differences between require and include, include_once and require_once? : Sql dba
what is a database? : Sql dba
Is crud a cuss word?
What are records give examples?
What is right join sql?
What is a design view?
Do we need commit after truncate?
Explain what is a view?
What is the basic structure of an sql?
How to test for null values?
What is coalesce in sql?
Which command is used to delete a package?