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

What is the difference between left outer join and left join?

997

Can there be more than one function with a similar name in a pl/sql block?

986

What is the purpose of a sql?

977

How many joins in sql?

1016

How to pipe multiline string to isql?

1008

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2572

How is a process of pl/sql compiled?

1162

What is package in pl sql?

1028

explain the difference between delete , truncate and drop commands? : Sql dba

1097

Explain the significance of the & and && operators in pl sql.

1009

Does sql backup shrink transaction log?

983

Why do you partition data?

1026

What is foreign key in sql with example?

940

What is %s in sql?

1032

What is the difference between joins?

1045