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

How to create an oracle database?

596

what is difference between sql plus and sql*plus? (not sql and sql plus).

3358

Explain the use of grant option in exp command.

592

How to create a new tablespace in oracle?

567

Why is oracle database so popular?

576

What do you mean by a deadlock?

524

what are the default admin accounts in Oracle 10g ?

517

What is columnar storage what is the advantage?

556

What do you mean by group by clause?

569

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1452

How to convert dates to characters in oracle?

588

What is the difference between pre-select and pre-query?

631

What is the sql query to concatenate column values from multiple rows in oracle?

571

What is oracle open database communication (odbc)?

565

How to declare a local variable?

608