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 to establish administrator authentication to the server?

1026

What is the data pump import utility?

1020

When do you get a .pll extension in oracle?

1130

How to rename an index?

1053

How to create a new table in your schema?

1069

Explain the use of tables option in exp command.

1100

What are set operators?

1066

What is a table index?

1076

is there a tool to trace queries, like profiler for sql server?

1133

Point out the difference between user tables and data dictionary?

970

How can I get column names from a table in oracle?

1036

What is meant by recursive hints in oracle?

1073

What is Reduced List of Values?

2150

Differentiate between function and procedure in oracle.

1053

State any two functions of oracle?

1028