select rownum, salary from (select salary from employees order by salary de

how to findout the 100th maximum salary

Question Posted / xyz

Answer Posted / xyz

select rownum, salary from (select salary from employees order by salary desc)
where romnum<=100

Is This Answer Correct ?

0 Yes

8 No

Please Help Members By Posting Answers For Below Questions

how can we destroy the cookie? : Sql dba

1007

Is and as keyword in pl sql?

954

What are different types of keys?

1100

Why do we need view in sql?

982

explain what is mysql? : Sql dba

1078

How do I restart sql?

963

Can we change the table name in sql?

937

What is benefit of creating memory optimized table?

970

What is a parameter query?

1075

Does execute immediate commit?

1216

Mention what are different methods to trace the pl/sql code?

1201

what is meant by nl2br()? : Sql dba

1031

Can we use having without group by in sql?

982

What are properties of the transaction?

998

What are conditional predicates?

1056