Hi, Select sal from emp e where 3>=(select count (Sal) from em

Find out the 3rd highest salary?

Question Posted / satya

Answer Posted / satya

Hi,

Select sal from emp e where 3>=(select count (Sal)
from emp where sal>e.sal) order by sal desc;

Regards,
Satya.k

Is This Answer Correct ?

23 Yes

35 No

Please Help Members By Posting Answers For Below Questions

How to add, remove, modify users using sql?

977

what is a field in a database ? : Sql dba

988

What is difference between hql and sql?

990

What does data normalization mean?

896

What is synonyms?

999

How to run pl/sql statements in sql*plus?

1020

Who is the owner of mysql database?

1000

What is data abstraction in sql?

964

Why do we use sql constraints?

1122

How many sql databases can you have on one server?

1016

How many sql are there?

924

Does access use sql?

967

how to select first 5 records from a table? : Sql dba

918

What is clustered index in sql?

1000

What is right join in sql?

1020