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 the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1605

What happens to the current transaction if the session is ended?

526

Explain an exception?

566

What is bulk load in oracle?

594

Hi Can any one tell me what are the API's used in requisition import.

1485

Compare and contrast between sql and sql server and explain its various functions?

528

How to test null values?

678

In the oracle version 9.3.0.5.0, what does each number shows?

748

What is the parameter mode that can be passed to a procedure?

574

What is hot backup and logical backup?

608

What the is the diff between local index and global index. give some example.

1136

How to select some rows from a table in oracle?

598

What is archive log in Oracle?

598

What is the difference between I and G in Oracle?

603

What is the difference between view and materialized view in Oracle?

608