SELECT * FROM ( SELECT NAME ,SALARY ,RANK() OVER (order b

how to select second mauximum value in a given table under salary column

Question Posted / sonthosh

Answer Posted / sonthosh

SELECT * FROM
(
SELECT
NAME
,SALARY
,RANK() OVER (order by salary desc) RANK
FROM EMPLOYEE)
WHERE RANK = 2

Is This Answer Correct ?

7 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How view is different from a table?

1044

What is a system tablespace and when it is created?

976

What is PL/SQL ?

2080

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2050

How can I create database in oracle?

1031

How can I introduce multiple conditions in like operator?

991

What is an oracle database table?

1018

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1885

Does oracle charge for java?

1060

What is archive log in Oracle?

1135

How to insert a record into a table?

1076

Difference between oracle's plus (+) notation and ansi join notation?

1111

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2143

What are the various constraints used in oracle?

1048

What is transport network substrate (tns) in oracle?

1047