how to findout the 100th maximum salary

Answer Posted / xyz

select rownum, salary from (select salary from employees order by salary desc)
where romnum<=100

Is This Answer Correct ?    0 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is percent sign in sql?

720


In what condition is it good to disable a trigger?

556


Why left join is used in sql?

518


What are the types of join and explain each?

581


what are the authentication modes in sql server? How can it be changed? : Sql dba

703






What is mutating trigger?

585


How long does it take to learn pl sql?

609


What is sql injection vulnerability?

494


What is difference sql and mysql?

535


Does a primary key have to be a number?

522


What is normalisation and its types?

550


What is difference between table and view?

526


what are all the different normalizations? : Sql dba

509


Why is a trigger used?

529


How do you write an inner join query?

516