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 SQL access advisor in Oracle?

1158

defination of bitmap index

2073

In what script is snap$ created? In what script is the scott/tiger schema created?

2674

How to turn on or off recycle bin for the session?

1064

What are the uses of a database trigger?

956

What do you mean by merge in oracle?

959

How to create a table index?

1095

How to display row numbers with the records?

1047

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1894

Explain rename?

945

What are the ansi data types supported in oracle?

922

What is recovery manager in Oracle?

1018

What is sequence?

1040

what is meant by magic query

2155

What are the roles of dba?

1039