SELECT SAL FROM (SELECT SAL,DENSE_RANK() OVER(ORDER BY SAL DESC) RANK FROM

Query to get max and second max in oracle in one query ?

Question Posted / satish

34 Answers
65575 Views
CTS, Keane India Ltd, TCS, Wipro, I also Faced
E-Mail Answers

Answer Posted / satish

SELECT SAL FROM (SELECT SAL,DENSE_RANK() OVER(ORDER BY SAL DESC) RANK FROM EMP) WHERE RANK=2;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to assign query results to variables?

1057

Where do you use decode and case statements?

1003

Briefly explain what is literal? Give an example where it can be used?

1049

How different is ms access and oracle?

1050

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2358

Is oracle a programming language?

998

What are the different types of modules in oracle forms?

1006

How do I know if oracle client is installed on windows?

1032

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2272

How to use like conditions in oracle?

1070

How much memory your 10g xe server is using?

1109

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2034

What is a read only transaction in oracle?

1032

Explain what are synonyms used for?

1045

List the various oracle database objects?

1062