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 are the different dml commands in sql?

1170

write an sql query to find names of employee start with 'a'? : Sql dba

1027

What are aggregate and scalar functions?

1017

What trigger means?

977

Can we perform dml on view?

1042

What is the difference between partition and index?

983

What is difference between hql and native sql?

1166

Is hadoop a nosql?

998

What is nvl?

1063

How do you modify a table in sql?

1118

Can you have more than one key in a database?

935

How does a covering index work?

956

What is pl sql block in dbms?

1001

How do you exit in sql?

1106

How do I tune a sql query?

974