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 are the difference between clustered and a non-clustered index? : Sql dba

979

what is the difference between char and varchar data types? : Sql dba

1003

How do I run sql profiler?

1008

Is record in oracle pl sql?

904

What is PL/SQL Records?

1116

What is a pragma statement?

1204

How do I remove all records from a table?

1026

What do you know by pl/sql cursors?

1038

What is nvarchar in sql?

887

Is there any restriction on the use of union in embedded sql?

1103

How to pronounce postgresql?

1009

How many sql core licenses do I need?

884

What is a null value?

1089

What is Histogram?

1507

What is varchar data type in sql?

1016