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

How many types of functions are there in sql?

675


What are the different types of database management systems?

728


What does varchar include?

692


how to use in conditions? : Sql dba

700


How to add, remove, modify users using sql?

750


Can we create view in stored procedure?

693


What is pls integer?

786


What does t sql mean?

706


describe mysql connection using mysql binary. : Sql dba

757


What is the difference between left and left outer join?

696


Give the order of sql select?

840


what are the join types in tsql? : Transact sql

762


What will you get by the cursor attribute sql%found?

711


What is sqlca in db2?

702


What is the sql query to display the current date?

764