select a.salary from emp a where 3=(select count(distinct(b.salary))

Find out the 3rd highest salary?

Question Posted / lalit dwivedi

Answer Posted / lalit dwivedi

select a.salary
from emp a
where 3=(select count(distinct(b.salary))
from emp b
where a.salary<=b.salary)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do you declare a user-defined exception?

1003

Explain commit, rollback and savepoint.

974

how to rename an existing column in a table? : Sql dba

996

What is a call statement? Explain with an example.

988

What is right join sql?

950

What are different categories of sql commands?

1111

how to include comments in sql statements? : Sql dba

937

what are string data types? : Sql dba

1018

What is procedure function?

1035

How do I install microsoft sql?

1027

What is java sql drivermanager?

1066

Why do we need view in sql?

966

What will you get by the cursor attribute sql%found?

946

What is cte?

960

Explain what is a view?

1038