how to findout the 100th maximum salary

Answer Posted / suresh

select sal from emp e
where 100=(select count( distinct sal) from emp where
e.sal<=sal)

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I copy a table in sql?

519


How many clustered indexes can be created on a table?

595


Can a table contain multiple foreign key’s?

581


Can we use ddl commands in pl sql?

563


What is sqlcontext?

553






What is the difference between left join and right join?

502


What are different methods to trace the pl/sql code?

546


Which is better cte or subquery?

547


What is the process of copying data from table a to table b?

602


What is equi join in sql?

617


What are user defined functions?

586


how to calculate expressions with sql statements? : Sql dba

532


What is data manipulation language?

703


What is a database event trigger?

601


Write a query to display the current date in sql?

522