SELECT * FROM Employee e WHERE 2=(SELECT COUNT(DISTINCT Salary) FROM Emplo

how to get second highest salary in SQL(as/4000

Question Posted / selvaraj v , anna univ coe

SELECT * FROM Employee e
WHERE 2=(SELECT COUNT(DISTINCT Salary) FROM Employee x
WHERE x.Salary >= e.Salary);

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I make my sql query run faster?

941

Why is sharding used?

993

What is foreign key sql?

985

Can we use delete in merge statement?

1037

Write the alter statement to enable all the triggers on the t.students table.

1123

How do you create a unique index?

1044

How can a function retun more than one value in oracle with proper example?

1072

Why functions are used in sql?

988

What is an implicit commit?

1048

Why do we use %rowtype & %type in plsql?

1046

What does where 1/2 mean in sql?

1063

What is the purpose of a secondary key?

963

What is the maximum database size for sql express?

1019

What are the most important ddl statements in sql?

1109

Can we update views in sql?

938