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 the difference between function and procedure in pl/sql?

1014

What does trigger mean in psychology?

913

what are the authentication modes in sql server? : Sql dba

998

How can the performance of a trigger be improved?

991

What are sql commands?

935

What is before trigger?

946

what is the difference between undefined value and null value? : Sql dba

1038

What is the main difference between sql and pl/sql?

1027

Is sql dba a good career? : SQL DBA

940

What is the plv (pl/vision) package offers?

981

Does sqlite need a server?

994

What is the difference between local variables and global variables?

1069

What does joining a thread mean?

973

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

933

what is acid property in database? : Sql dba

960