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

How to convert raw data type into text in oracle? Explain

953

What is private procedure oracle?

958

What is redo log?

1009

What is the difference between translate and replace in oracle?

1116

Explain about achiever in sql?

981

What are triggers in oracle?

978

What are the attributes of cursor?

991

What is the difference between postgresql and oracle?

980

What is user managed backup in Oracle?

1078

What is not equal to in oracle?

954

What is the sid in oracle?

904

How to connect to a local oracle 10g xe server?

941

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

1036

What are the different windows events activated at runtime ?

2838

What is a package ? What are the advantages of package ?

1036