how to findout the 100th maximum salary

Answer Posted / goutham4mail@gmail.com

select top 1 * from Emp where Sal in
(select top 100 Sal from Emp order by Sal desc) order by
Sal asc

Is This Answer Correct ?    3 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you delete duplicates in sql query using rowid?

720


How to create an array in pl/sql?

771


What is scalar function in sql?

706


What is difference between inner join and cross join?

715


What is sql procedures and functions?

746






what is timestamp in mysql? : Sql dba

742


Why is theta join required?

834


How can I change database name in sql?

703


What is mutating error?

697


What are the advantages of normalization?

788


How do I get sql certification?

704


How do I clear the screen in sql plus?

756


What operators deal with null?

813


What is spool?

790


What is dense_rank in sql?

696