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

Give the order of sql select?

1137

Is primary key clustered index?

950

What does select top 1 do in sql?

1097

What is sql query limit?

980

How do I make my sql query run faster?

941

Explain ddl statements in pl/sql?

1010

What is auto increment?

1000

What are sql triggers used for?

995

what is 'mysqlcheck'? : Sql dba

1015

What is the main difference between sql and pl/sql?

1096

what are the advantages of using stored procedures? : Sql dba

1105

what is dbms? : Sql dba

995

Can we use delete in merge statement?

1039

What are some predefined exceptions in pl/sql?

1167

Name the operator which is used in the query for pattern matching?

954