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

Can delete statement be rollbacked?

1065

What is the best sql course?

1062

What is your daily office routine?

2351

What is the current version of sql?

1106

Is inner join faster than left join?

1287

how to escape special characters in sql statements? : Sql dba

1124

Can we rollback truncate?

1083

What is the current version of postgresql?

1188

Does group by remove duplicates?

1120

Is primary key clustered index?

1026

what are the advantages of sql ? : Sql dba

1153

how many tables will create when we create table, what are they? : Sql dba

1154

define sql insert statement ? : Sql dba

1108

Is primary key always clustered index?

1101

what is collation? : Sql dba

1242