SELECT * FROM ( SELECT employee_id, last_name, salary, RANK() OVER (ORDE

how to get second highest sal of emp table

Question Posted / rakhi

Answer Posted / rakhi

SELECT *
FROM (
SELECT employee_id, last_name, salary,
RANK() OVER (ORDER BY salary DESC) EMPRANK
FROM employees)
WHERE emprank = 2;

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is a user account in oracle?

1069

How to define an explicit cursor in oracle?

989

How many file formats are supported to export data?

1139

What is oracle analytical function?

1032

What is Library Cache in Oracle?

1077

How do we display rows from the table without duplicates?

920

How to delete a user account in oracle?

916

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2302

Explain an exception and its types?

1012

How to connect to a remote server?

1055

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5417

Explain index?

1205

What is the use of aggregate functions in oracle?

981

How do we get field detail of a table?

1022

How to write a query with a left outer join in oracle?

1004