a query to select maxmun 3 salaries of employee table
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 |
Post New Answer View All Answers
How to store pictures on to the database?
Explain what are clusters?
How to retrieve values from data fields in record variables?
How to update a table row with a record?
How to compare dates in oracle sql?
How to invoke the data pump export utility?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How to synchronize 2 schema's objects?
What happens to indexes if you drop a table?
What is a sub query? Describe its types?
Explain what are the characteristics of data files?
Can the query output be sorted by multiple columns in oracle?
What happens if you use a wrong connect identifier?
what is the use of system.effective.date variable in oracle?
What is a lookup table in oracle?