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

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

Please Help Members By Posting Answers For Below Questions

What is the difference between post-database commit and post-form commit?

1284

What happens if variable names collide with table/column names?

1262

Explain integrity constraint?

1205

Why does oracle 9i treat an empty string as null?

1124

Which is better Oracle or MS SQL? Why?

5029

How a tablespace is related to data files?

1162

What is Reduced List of Values?

2242

State all possible different index configurations a table can possibly have?

1096

How to create a new view in oracle?

1125

What are group functions in oracle?

1091

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

3021

what is the difference between substr and instr function in oracle?

1140

How to bring a tablespace offline?

1112

How to download oracle database 10g xe?

1063

How to use subqueries in the from clause in oracle?

1165