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
Which is faster union or join?
how can we know the count/number of elements of an array? : Sql dba
How to create a menu in sqlplus or pl/sql?
How is pl sql different from sql?
What is plpgsql language?
How do I pipe the output of one isql to another?
What is %rowtype in pl sql?
How do I run a query in pl sql developer?
tell me about various levels of constraint. : Sql dba
Can you selectively load only those records that you need? : aql loader
What is a natural join sql?
Explain the methods used to protect source code of pl/sql.
What is sql catalog?
Show the two pl/sql cursor exceptions.
What is the difference between microsoft sql and mysql?