select sal from ( select row_number() over (order by sal desc) as rno,sal

how to findout the 100th maximum salary

Question Posted / lince

Answer Posted / lince

select sal from
(
select row_number() over (order by sal desc) as rno,sal
from Emp
)T
where T.rno=100

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain sql data types?

1037

what is a trigger? : Sql dba

976

what is sql in mysql? : Sql dba

1123

How do you update sql?

915

What are the types of join and explain each?

989

What is pl sql record in oracle?

971

What is meaning of <> in sql?

1023

How to test for null values?

985

What is the use of function in sql?

1029

What are all the different normalization?

979

Which constraints we can use while creating database in sql?

1018

Why we use stored procedure instead of query?

953

Can a varchar be a primary key?

955

Are left and right joins the same?

1003

What is the importance of sqlcode and sqlerrm?

1280