select * from emp e1 where (3-1) = (select count(distinct (e2.sal)) from e

find out the third highest salary?

Question Posted / sanjeev kumar p

Answer Posted / sanjeev kumar p

select * from emp e1 where (3-1) = (select count(distinct
(e2.sal)) from emp e2 where e2.sal>e1.sal)

Is This Answer Correct ?

99 Yes

51 No

Please Help Members By Posting Answers For Below Questions

How to define a variable to match a table column data type?

990

What is the difference between 10g OEM and 11g OEM?

965

How to sort output in descending order in oracle?

1047

What do you mean by a deadlock?

1065

What is set operator oracle?

983

What is the scope of a local variable?

1067

How to compare dates in oracle sql?

1107

What is the difference between formal parameters and actual parameters?

1089

Explain how are indexes update?

1067

What is the Tune Query

2295

What are the attributes that are found in a cursor?

1078

what are the advantages of running a database in archive log mode?

2205

How to declare a local variable?

1125

How to retrieve data from an cursor to a record?

1104

What is a cognitive schema?

972