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

Find out the 3rd highest salary?

Question Posted / a.jyothsna

Answer Posted / a.jyothsna

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

Is This Answer Correct ?

100 Yes

45 No

Please Help Members By Posting Answers For Below Questions

What is triggering circuit?

1017

What is the difference between rename and alias?

1270

What does fetching a cursor do?

1022

How do you modify a trigger?

876

How are sql commands classified?

1038

Why commit is not used in triggers?

994

What are sql triggers used for?

959

What is the default isolation level in sql server? : Transact sql

964

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1099

What is prepared statement in sql?

998

What is java sql package?

1026

What is spool?

993

Explain the the delete statements in sql?

982

Which query operators in sql is used for pattern matching?

904

Who is the owner of mysql database?

1002