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

how to find the second highest salary from emp table?

Question Posted / chiguru&

Answer Posted / chiguru&

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is inner join in sql?

1004

How to rename a column in the output of sql query?

1005

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

957

what is the difference between nested subquery and correlated subquery?

988

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

903

Can we connect to postgresql using sql developer?

937

Are there any features that are decommissioned in 11g that are not present in 11g?

2069

what are the nonstandard string types? : Sql dba

1085

Which tcp/ip port does sql server run?

958

Why cross join is used?

1024

Can you skip header records while loading? : aql loader

976

How do I add a database to sql?

1064

How to execute a stored procedure?

1036

How do you update f as m and m as f from the below table testtable?

1792

How can you save or place your msg in a table?

954