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

how would concatenate strings in mysql? : Sql dba

742


How do I enable sql encryption?

715


How do I create a sql database?

710


What is the difference between sql, mysql and sql server?

694


What is sorting in sql?

673






Is sql better than excel?

701


how to use 'mysql' to run sql statements? : Sql dba

738


Is it possible for a table to have more than one foreign key?

774


What are the operators used in select statements?

773


What does pl sql stand for?

851


what is a database? : Sql dba

809


What is normalization? How many normalization forms are there?

747


What is the most important ddl statements in sql are?

727


What is foreign key in sql with example?

680


Does sqlite need a server?

740