select rnk, no,sal from ( SELECT DENSE_rank()over(partition by no order by

a query to select maxmun 3 salaries of employee table

Question Posted / dhanya

Answer Posted / dhanya

select rnk, no,sal from (
SELECT DENSE_rank()over(partition by no order by sal desc ) RNK,d2.no,sal FROM DUMMY2 d2)
where rnk =2;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to establish administrator authentication to the server?

981

What does sharding mean?

943

What is transport network substrate (tns) in oracle?

989

Explain the different normalization forms?

1007

Why use resource manager in Oracle?

1048

How to drop a stored procedure in oracle?

993

How translate command is different from replace?

1004

How to count duplicated values in a column in oracle?

981

what happened to the global index when I truncate the data in one of the partition?

1959

Explain joins in oracle?

976

How to list all indexes in your schema?

1026

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

914

How to loop through data rows in the implicit cursor?

1011

How do you store pictures in a database?

945

What is redo log?

1003