how to findout the 100th maximum salary

Answer Posted / parul verma

select min(salary) from (select distinct salary from emp
where salary is not null order by salary desc) where rownum
<=100;

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are stored procedures in mysql?

760


What is the command used to fetch first 5 characters of the string?

1094


Why are sql stored procedures used?

798


Is sql low level language?

757


What company owns postgresql?

769






How to place comments in pl/sql?

797


Why having clause is used in sql?

726


which command using query analyzer will give you the version of sql server and operating system? : Sql dba

702


how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

690


Does sql view stored data?

722


How are functions and procedures called in PL/SQL?

802


how is myisam table stored? : Sql dba

782


What is type and rowtype in pl sql?

741


What is sql mysql pl sql oracle?

784


How do you concatenate in sql?

723