SELECT * FROM (SELECT ENAME,SAL,DENSE_RANK() OVER(ORDER BY SAL DESC) RN FRO

how to select second mauximum value in a given table under salary column

Question Posted / u.radha

6 Answers
9517 Views
Sapient, I also Faced
E-Mail Answers

Answer Posted / u.radha

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

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to rollback the current transaction in oracle?

1039

What is redo log?

1041

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1976

What are a collation and state the different types of collation sensitivity?

1149

How to use "if" statements on multiple conditions?

1142

What is the difference between Delete, Truncate and Drop in Oracle?

1106

What is program global area (pga) in oracle?

1011

Can we call procedure inside function in oracle?

1062

What are the extensions used by oracle reports?

1024

What is coalesce function?

1053

How to rebuild an index in oracle?

1009

How to create a stored program unit?

1194

What are the types of partitions in oracle?

1017

What is user managed backup in Oracle?

1120

Explain compound trigger in oracle?

1019