how to findout the 100th maximum salary

Answer Posted / soumya

select * from (select rownum, salary from emp order by
salary ) where rownum=100;

Is This Answer Correct ?    3 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sql better than access?

546


What are the properties of a transaction?

564


Do we need commit after truncate?

613


What is a recursive join sql?

597


How many scalar data types are supported in pl/sql?

524






What are conditional predicates?

587


what are local and global variables and their differences? : Sql dba

541


Does sql*plus also have a pl/sql engine?

563


When should I use nosql database?

553


What is the difference between truncate and drop statements?

579


How delete all data from table in sql?

573


What is left inner join in sql?

519


How can you tell the difference between an index and a view?

494


What is trigger in pl sql with examples?

525


What is plpgsql language?

534