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 sql constraints? Which constraints we can use while creating database in sql?

1042

Why are indexes and views important to an organization?

956

How do I copy a table in sql?

988

How to fix oracle error ora-00942: table or view does not exist

1014

What does plv msg allows you to do?

1140

Explain mutating table error.

1202

Explain the steps needed to create the scheduled job?

1038

What is nosql db?

969

What are variables in pl sql?

1167

What is crud stand for?

996

who introduced sql?

1018

What is difference between sql and excel?

1091

Which table is left in join?

978

how to convert dates to character strings? : Sql dba

1169

Is coalesce faster than isnull?

966