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

Find out the 3rd highest salary?

Question Posted / abhay

Answer Posted / abhay

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

somebody tell me he logic....!

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Differentiate between pl/sql and sql?

1133

What does the file extension accdb stand for?

961

What mean sql?

995

How to connect a sql*plus session to an oracle server?

1114

What is the difference between sql and isql*plus?

1075

What does a pl/sql package consist of?

964

Which is faster joins or subqueries?

974

How to change the order of columns in Oracle SQL Plus ?

1042

What is the purpose of using pl/sql?

1127

What is difference between nchar and nvarchar?

1010

Explain correlated query work?

1042

What are the types of records?

981

what is sql? : Sql dba

1005

What is sql procedures and functions?

994

what is timestamp in mysql? : Sql dba

1056