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 rename an existing table?
How to select some rows from a table in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How does oracle handle read consistency?
Which is better Oracle or MS SQL? Why?
How to use group functions in the select clause using oracle?
What is the data pump import utility?
How to get execution path reports on query statements?
List the various oracle database objects?
Can we insert data in view oracle?
What is the difference between substr & instr functions?
How do I recompile a procedure in oracle?
How to assign a table row to a record variable?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
How to load data from external tables to regular tables?