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

What is a cursor and what are the steps need to be taken?

1290

What is where clause in oracle?

1076

How do I manually uninstall oracle client?

1152

What are the uses of a database trigger?

1037

How to use select statement to count the number of rows in oracle?

1093

How to loop through data rows in the implicit cursor?

1120

How to drop an index?

1015

What is system tablespace?

1153

What are the benefits of ordbms?

1138

How translate command is different from replace?

1142

What happens to the current transaction if a ddl statement is executed?

1060

Give syntax for SQL and ORACLE joins.

1146

How to drop a stored procedure in oracle?

1106

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2442

Explain an index segment?

1160