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
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How to define a specific record type?
What is concurrency in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is enter substitution variable in oracle?
How to use "in out" parameter properly?
Who developed oracle & when?
What are the differences between primary key and unique key?
Explain the use of analyse option in exp command.
How to invoke the data pump import utility?
What is oracle datasource?
What is an Oracle index?
What are the differences between date and timestamp in oracle?
Explain oracle left join with an example?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?