select sgp from (select sgp,dense_rank() over (order by sgp desc) as row

how to findout the 100th maximum salary

Question Posted / john bershan

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

Please Help Members By Posting Answers For Below Questions

what are the different type of sql's statements ? : Sql dba

980

What is the difference between drop and truncate commands?

1113

what is 'mysqlimport'? : Sql dba

1115

Can we join 3 tables in sql?

1109

what are properties of a transaction? : Sql dba

1139

Explain the uses of database trigger.

1179

What are the different types of dbms?

1067

Are there any features that are decommissioned in 11g that are not present in 11g?

2197

explain what is mysql? : Sql dba

1133

what are the advantages of using stored procedures? : Sql dba

1157

What are the different types of sql commands?

1179

What are the limitations of sql express?

1122

Can there be more than one function with a similar name in a pl/sql block?

1045

Can %notfound return null after a fetch?

1105

What is left join in postgresql?

1092