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

What is bulk load in oracle?

1071

Can we insert data in view oracle?

1042

How to end the current transaction in oracle?

1030

Explain the use of full option in exp command.

1116

What is the use of file param in imp command?

1165

How to name query output columns in oracle?

1188

What are the advantages of oracle?

1028

master table and child table performances and comparisons in Oracle ?

2138

What is coalesce function?

1078

How to use windows user to connect to the server?

990

What is SQL access advisor in Oracle?

1194

Explain coalesce function?

1207

Â What are the oracle DML commands possible through an update strategy?

1066

What is the database name in oracle?

1021

What are the different pseudo commands? Explain in general?

1080