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

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2260

What are the differences between blob and clob in oracle?

1033

Explain mutating triggers.

974

Difference between cartesian join and cross join?

960

What is an oracle function?

1075

Can you tell me how to add new column in existing views?how?How is possible?

1372

How to resolve the ORA-39133 error in Oracle?

1034

What is ordinary table in oracle?

1077

Please explain oracle left join with an example?

960

What is null value in oracle?

1037

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1939

Explain the use of owner option in exp command.

994

What is recycle bin in Oracle?

1087

Explain the use of inctype option in exp command.

978

Can you create a synonym without having a table?

980