Select ename from emp e where 2=(select count(distinct(Sal)) from emp wher

Find out the 3rd highest salary?

Question Posted / vishal beri

Answer Posted / vishal beri

Select ename from emp e where 2=(select count(distinct(Sal))
from emp where sal>e.sal)

Is This Answer Correct ?

3 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Why do we use partitions in sql?

1036

What is the difference between microsoft access and sql?

1006

What is faster join or subquery?

1001

What is a trigger in sql?

1193

how to run 'mysql' commands from a batch file? : Sql dba

1094

What is nosql example?

1017

What is sql analyzer?

998

Which function is used to return remainder in a division operator in sql?

1119

What is java sql connection?

1034

What is insert command in sql?

1108

What is before trigger?

990

Should I use mbr or gpt?

1013

What pl/sql package consists of?

1064

Is sql better than excel?

1122

How to raise user-defined exception with custom sqlerrm ?

1117