SELECT MAX(SAL) FROM TEST_123 WHERE SAL NOT IN (SELECT MAX(SAL) FROM TEST

how to find the second highest salary from emp table?

Question Posted / vinod

Answer Posted / vinod

SELECT MAX(SAL) FROM TEST_123 WHERE SAL NOT IN (SELECT
MAX(SAL) FROM TEST_123)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are the performance and scalability characteristics of mysql? : Sql dba

944

What is the sql case statement?

954

How to run sql*plus commands in sql developer?

1085

Explain ttitle and btitle.

1058

what is the syntax for using sql_variant_property? : Transact sql

990

Define the select into statement.

997

How to load data with sql*loader?

1000

how to create a new view in mysql? : Sql dba

895

what is a trigger in mysql? Define different types of trigger. : Sql dba

1012

what is primary key? : Sql dba

956

Is coalesce faster than isnull?

909

what is column? : Sql dba

962

what is the use of double ampersand (&&) in sql queries?

1117

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2529

What is the difference between left outer join and left join?

945