SELECT * FROM ( SELECT EMPLOYEECODE, SAL, Rank() OVER (ORDER BY SAL DESC

find out the third highest salary?

Question Posted / abbas

Answer Posted / abbas

SELECT * FROM
(
SELECT EMPLOYEECODE, SAL, Rank() OVER (ORDER BY SAL DESC )
RANKNEW FROM EMPLOYEE)
WHERE RANKNEW = 3

Is This Answer Correct ?

9 Yes

8 No

Please Help Members By Posting Answers For Below Questions

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1087

Can you have more than one content canvas view attached with a window ?

2330

How to shutdown your 10g xe server?

1147

Define oracle database

1041

How oracle handles dead locks?

1064

what are steps for interface? where is exchange rate defined in which table?

2158

What is object data modeling?

960

Why is oracle used?

937

Explain oracle’s server parameter file.

989

What is tns entry?

1147

How to select an oracle system id (sid)?

1064

Explain the use of tables option in exp command.

1115

How to handle a single quote in oracle sql?

1050

How to name query output columns in oracle?

1183

What are the various constraints used in oracle?

1041