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

How to add, remove, modify users using sql?

1039

Why primary key is required?

1012

Why commit is not used in triggers?

1046

What is recursive join in sql?

1032

Why do we use joins in sql?

973

What are sql objects?

1085

What is orm in sql?

1052

What is memory optimized?

1091

When are we going to use truncate and delete?

991

Does db2 use sql?

954

Is natural join same as inner join?

947

How many types of keys are there in sql?

1042

What is the use of function in sql?

1098

how to create a new table in mysql? : Sql dba

992

what is a trigger in mysql? Define different types of trigger. : Sql dba

1074