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 are archived logs?

2166

What are the major difference between truncate and delete?

1010

What language does oracle use?

1065

What is an oracle recycle bin?

958

What are the most common interview questions on ETL Testing for experience?

1098

What is the data pump import utility?

1000

What is bind variable in oracle 11g?

1014

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2121

What happens if recursive calls get out of control?

1037

How to define a record variable to store a table row?

1031

How to write an inner join with the where clause in oracle?

1022

How to open a cursor variable?

991

What is the fastest query method to fetch data from the table?

1322

How do I manually uninstall oracle client?

1049

How to use attributes of the implicit cursor in oracle?

969