select * from (select rownum, salary from emp order by salary ) where row

how to findout the 100th maximum salary

Question Posted / soumya

Answer Posted / soumya

select * from (select rownum, salary from emp order by
salary ) where rownum=100;

Is This Answer Correct ?

3 Yes

9 No

Please Help Members By Posting Answers For Below Questions

what is the difference between join and union? : Sql dba

1122

What is a memo field?

976

Is grant a ddl statement?

904

What is the difference between a procedure and a function?

1126

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1173

What is the difference among union, minus and intersect?

1009

what is msql? : Sql dba

994

what is a trigger in mysql? : Sql dba

1153

How does an execution block start and end in pl sql?

957

Can we use joins in subquery?

1169

what is a unique key ? : Sql dba

1102

Is sql a oracle?

984

How do you create an update query?

970

Can a trigger call a stored procedure?

1077

What type of join is sql join?

990