Select * From employee emp1 Where 2 = (Select Count(Distinct(emp1.salary))

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

Question Posted / prabir

Answer Posted / prabir

Select * From employee emp1 Where 2 = (Select
Count(Distinct(emp1.salary)) From employee emp2 Where
emp2.salary > emp1.salary)

Is This Answer Correct ?

3 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Which join is like an inner join?

1022

What is nested table in pl sql?

1066

What is not null in sql?

1053

What is clause in sql?

1108

what is 'mysqld'? : Sql dba

966

How do you use join?

937

What is a memo field?

966

What are conditional predicates?

1056

define join and explain different type of joins? : Sql dba

949

What is the difference between row level and statement level trigger?

1018

What are different clauses used in sql?

1112

What is data types in sql?

1006

What is where clause in sql?

1035

How do you create a unique index?

1044

What is dml statement?

950