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 acid property in database? : Sql dba

1038

What is trigger in pl sql?

1009

Why we use sql profiler?

964

What is foreign key sql?

995

What are secondary keys?

979

What is the function that is used to transfer a pl/sql table log to a database table?

1031

What are records give examples?

1016

What is a function in oracle pl sql?

1046

Is json a nosql?

985

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1275

Is join same as left join?

1046

How to find 3rd highest salary of an employee from the employee table in sql?

1084

is it possible to pass an object or table to a procedure as an argument?

1139

Name three sql operations that perform a sort.

1020

Can we group by two columns in sql?

1002