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

How exception is different from error?

1065

What is sql deadlock?

1216

How do I run sql?

1254

What is an inconsistent dependency?

1087

What is a common use of group by in sql?

1096

What is data abstraction in sql?

1066

Determine if oracle date is on a weekend?

1089

Is not equal in sql?

1062

What is a sql driver?

1041

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1117

what are the different index configurations a table can have? : Sql dba

1042

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1123

How to process query result in pl/sql?

1201

What is package in pl sql with an examples?

1087

Explain the difference between 'between' & 'and' operators in sql

1046