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

What is a column in a table?

546

What does seeding a database mean?

524

What is normalisation in sql?

546

What is scalar function in sql?

527

How do I run a program in pl sql?

496

Explain how can you save or place your msg in a table?

593

Explain the the delete statements in sql?

574

Why do we need pl sql?

547

What is a constraint?

565

Is left join inner or outer?

581

What does trigger mean in psychology?

532

what are properties of a transaction? : Sql dba

557

how many values can the set function of mysql take? : Sql dba

530

What is blind sql injection?

571

What is difference between mysql and postgresql?

509