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 apply filtering criteria at group level in oracle?

1045

How to write a query with a right outer join in oracle?

1169

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1990

What is the difference between hot backup and cold backup in oracle?

1014

What is the difference between truncate & delete command?

1186

Is truncate autocommit in oracle?

1087

What is the relationship among database, tablespace and data file?

989

What is the usage of synonyms?

1143

What are dml statements in oracle?

1095

How to create a new table in oracle?

1159

How do I spool to a csv formatted file using sqlplus?

1038

What is the difference between formal parameters and actual parameters?

1089

Write a syntax for update query in oracle?

1036

Does oracle database need java?

1013

What is clustered table in Oracle?

1198