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

What is PL/SQL Records?

1190

Can procedure in package be overloaded?

1085

What are the most important characteristics of pl/sql?

1160

What is the difference between subquery and correlated query?

1065

How can I speed up sql query?

963

how to do backup entire database? : Transact sql

1146

What is optimistic concurrency control? : Transact sql

985

What is before and after trigger?

959

What is the benefit of foreign key?

1022

What is compilation error in pl sql?

979

What is application trigger?

1001

What is Difference Between Unique and Primary Key Constraints?

1107

how can we know the number of days between two given dates using mysql? : Sql dba

1048

What is sql and its types?

1192

What is meant by truncate in sql?

1068