Select * from (select distinct salary, dense

how to findout the 100th maximum salary

Question Posted / sanjay kumar

Answer Posted / sanjay kumar

Select * from
(select distinct salary, dense_rank()over (Order by salary desc) rk from emp)
Where rk=100;

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the mutating table and constraining table?

1032

Does a user_objects view have an entry for a trigger?

1020

What trigger means?

997

What is embedded sql in db2?

1024

what is datawarehouse? : Sql dba

1029

What is the difference between a primary key and a clustered index?

998

Explain sql data types?

1107

What are sql procedures?

1034

Can you have a foreign key without a primary key?

962

How is a process of pl/sql compiled?

1172

What can you do with pl sql?

1101

How many sql are there?

1007

What is user in sql?

1027

What is the difference between joins?

1047

What is database sql?

1058