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

What exactly do quotation marks around the table name do?

1024

How do I know if oracle is installed on windows?

984

Why do we use coalesce function in oracle?

1164

How to use select statement to count the number of rows in oracle?

1092

How to create a new table by selecting rows from another table?

1149

What is the use of oracle?

1075

How to name query output columns in oracle?

1240

What is recovery manager in Oracle?

1108

State and explain the different types of data models?

992

How can you use check constraints for self referential integrity?

1017

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3096

What is the usage of synonyms?

1211

What types of joins are used in writing subqueries?

1030

How will you write a query to get a 5th rank student from a table student_report?

1918

State all possible different index configurations a table can possibly have?

1100