how to findout the 100th maximum salary

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are all different types of collation sensitivity?

529


Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

694


explain what is mysql? : Sql dba

602


What is dynamic sql in pl sql?

499


Can there be 2 primary keys in a table?

559






What is sql clause?

545


Can we create view in stored procedure?

526


what is the difference between delete and truncate commands? : Sql dba

542


list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

516


How do sql triggers work?

556


what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

579


What is the difference between execution of triggers and stored procedures?

557


What is scalar function?

570


Give the order of sql select?

616


What is online transaction processing (oltp)?

605