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

Find out the 3rd highest salary?

Question Posted / srikanth

Answer Posted / srikanth

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

Is This Answer Correct ?

17 Yes

10 No

Please Help Members By Posting Answers For Below Questions

how can we know the number of days between two given dates using mysql? : Sql dba

1053

Which are the different case manipulation functions in sql?

1037

What is the least restrictive isolation level? : Transact sql

1080

What is the use of & in pl sql?

1054

Is join an inner join?

983

How do I view a table in sql?

1015

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2501

How to avoid using cursors?

1133

What are the ddl commands?

1021

How to display the records between two range in Oracle SQL Plus?

1159

What kind of join is join?

986

what are properties of a transaction? : Sql dba

1099

discuss about myisam index statistics collection. : Sql dba

962

what is a composite key ? : Sql dba

1072

Is it possible to create the following trigger: before or after update trigger for each row?

1297