how to findout the 100th maximum salary

Answer Posted / katasani rajesh reddy

select salary from(select salary from
order by salary)
where rownum<=100
minus
select salary from(select salary from
order by salary)
where rownum<=99

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sqlca in powerbuilder?

746


What is substitution variable in pl sql?

693


what are the differences between char and nchar? : Sql dba

797


Can we rollback after truncate?

754


Is subquery faster than join?

743






What is replication id?

683


What is the difference between local variables and global variables?

800


How insert into statements in sql?

789


What are different types of functions in sql?

723


Is inner join faster than left join?

874


What is foreign key sql?

748


Can we insert in sql function?

773


What is sap sql?

719


What are different types of queries in sql?

735


What is offset and limit in sql?

744