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 store pictures on to the database?

532

Explain what are clusters?

616

How to retrieve values from data fields in record variables?

572

How to update a table row with a record?

597

How to compare dates in oracle sql?

657

How to invoke the data pump export utility?

564

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1833

How to synchronize 2 schema's objects?

1690

What happens to indexes if you drop a table?

701

What is a sub query? Describe its types?

548

Explain what are the characteristics of data files?

629

Can the query output be sorted by multiple columns in oracle?

574

What happens if you use a wrong connect identifier?

504

what is the use of system.effective.date variable in oracle?

673

What is a lookup table in oracle?

542