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
what are the different type of sql's statements ? : Sql dba
What is the difference between drop and truncate commands?
what is 'mysqlimport'? : Sql dba
Can we join 3 tables in sql?
what are properties of a transaction? : Sql dba
Explain the uses of database trigger.
What are the different types of dbms?
Are there any features that are decommissioned in 11g that are not present in 11g?
explain what is mysql? : Sql dba
what are the advantages of using stored procedures? : Sql dba
What are the different types of sql commands?
What are the limitations of sql express?
Can there be more than one function with a similar name in a pl/sql block?
Can %notfound return null after a fetch?
What is left join in postgresql?