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

find out the third highest salary?

Question Posted / abbas

92 Answers
153812 Views
CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the uses of a database trigger?

1036

please explain.. DB architecture ...

2081

various types of hints and their usage

2751

What happens if you lost a data file?

1082

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1894

What is a cursor in oracle?

1232

How to execute the package in oracle?

1136

interview questions with answer for cts

2638

What is the Tune Query

2347

What is a subquery?

1192

What is pragma autonomous transaction in oracle?

1125

What are advantages of dateset in datastage?

2309

What is a read only transaction in oracle?

1080

How to delete a user account in oracle?

1022

How do I connect to oracle database?

1198