select min(sal) from (select sal from emp order by sal desc) where rownum&l

how to findout the 100th maximum salary

Question Posted / aswini

Answer Posted / aswini

select min(sal) from (select sal from emp order by sal desc) where rownum<=100

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How does join work in sql?

1007

what is a record in a database ? : Sql dba

1060

What are schema-level triggers?

1098

What are the indexing methods?

1041

How delete all records from table in sql?

977

What is the difference between inner join and left join?

984

What are the sql versions?

939

Are stored procedures faster than queries?

943

Is it possible to sort a column using a column alias?

1040

how to convert numeric values to character strings? : Sql dba

1100

How do you update a value in sql?

1039

Is left join faster than join?

1045

How do I find sql profiler?

934

What is difference between sql function and stored procedure?

1002

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1127