select e.* from emp e where &n=(select count(distinct e1.sal)from emp e

How to find only %th Highest Sal

Question Posted / pavan

Answer Posted / pavan

select e.* from emp e where &n=(select count(distinct e1.sal)from emp e1 where e.sal>e1.sal)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is pl sql useful?

1037

what is the difference between inner and outer join? Explain with example. : Sql dba

1063

How do you break a loop in pl sql?

1101

how to calculate the difference between two dates? : Sql dba

1112

What is trigger types of trigger?

1141

What does trigger mean in slang?

1123

What is trigger price?

1046

What does bitemporal mean?

1113

tell us something about heap tables. : Sql dba

1142

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

1056

what is uncommittable transactions? : Transact sql

1036

What does pragma mean?

1130

what is data control language? : Sql dba

1067

what is a field in a database ? : Sql dba

1096

Which join condition can be specified using on clause?

1012