how to findout the 100th maximum salary

Answer Posted / ethayan

select salary from (select salary from sample where
rownum<11 order by salary desc) where rownum<2

Is This Answer Correct ?    3 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When can we use the where clause and the having clause?

778


What is crud stand for?

746


What does select top 1 do in sql?

729


What is the difference between nested table and varray?

688


How to avoid using cursors? What to use instead of cursor and in what cases to do so?

868






What is dcl in sql?

694


Is pl sql a scripting language?

779


What is an index in sql with example?

712


What is difference between sql and excel?

696


How do I run pl sql in sql developer?

858


Can you have a foreign key without a primary key?

681


What is primary key and unique key?

762


What are few of the schema objects that are created using PL/SQL?

733


write an sql query to find names of employee start with 'a'? : Sql dba

775


Explain two easy sql optimizations.

770