how to findout the 100th maximum salary

Answer Posted / john bershan

select sgp from (select sgp,dense_rank() over (order by
sgp desc) as rownumber from t_policy_general)
where rownumber = '100';

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is faster union or join?

489


how can we know the count/number of elements of an array? : Sql dba

568


How to create a menu in sqlplus or pl/sql?

609


How is pl sql different from sql?

540


What is plpgsql language?

525






How do I pipe the output of one isql to another?

530


What is %rowtype in pl sql?

511


How do I run a query in pl sql developer?

560


tell me about various levels of constraint. : Sql dba

526


Can you selectively load only those records that you need? : aql loader

607


What is a natural join sql?

509


Explain the methods used to protect source code of pl/sql.

537


What is sql catalog?

555


Show the two pl/sql cursor exceptions.

609


What is the difference between microsoft sql and mysql?

507