how to findout the 100th maximum salary

Answer Posted / murali

select salary from (select salary from table order by salary
desc) v where rownum<=100

Is This Answer Correct ?    8 Yes 19 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are character functions in sql?

498


What is trigger point?

538


What mean sql?

583


what are sequences

1096


how to select first 5 records from a table? : Sql dba

509






Which constraints we can use while creating database in sql?

618


What are the types of dbms?

546


What is dml and ddl?

527


Are dml statements autocommit?

554


What is the difference between stored procedure and view?

532


Why schema is used in sql?

517


What do you know by pl/sql cursors?

569


what is text? : Sql dba

564


Can we use ddl statements in stored procedure sql server?

520


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1561