SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN (SELECT MAX(SALARY)

how to find the second highest salary from emp table?

Question Posted / jithu

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

Please Help Members By Posting Answers For Below Questions

Can we use pl sql in mysql?

1010

What is difference between sql and oracle?

1123

what is collation? : Sql dba

1147

What are the possible values for the boolean data field?

961

What is procedure and function in sql?

997

What is dbo in sql?

956

What is file based approach?

937

How can I delete duplicate rows?

1012

what are numeric data types? : Sql dba

1060

what are string data types? : Sql dba

1039

what is the stuff function and how does it differ from the replace function? : Sql dba

1043

What are the methods of filing?

935

How do I run a sql trace?

957

What is basic structure of pl sql?

1066

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1002