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 get maxsal , minsal, ename department wise in single query

1498

Is there an oracle sql query that aggregates multiple rows into one row?

930

Is it possible to insert comments into sql statements return in the data model editor ?

2509

How to get last row id?

937

How to run the anonymous block again?

1065

How to create an oracle database manually?

1017

How to use subqueries in the from clause in oracle?

1042

if you ctreate table identity

2312

How would you best determine why your MVIEW couldnt FAST REFRESH?

1835

Use of an integrity constraint is better to validate data. Explain

973

What is the data pump import utility?

968

what is the difference between data migration and production migration.

2274

Is oracle a programming language?

934

Query to retrieve record for a many to many relationship ?

2457

Explain the difference between a procedure and a function? What do you understand by those terms?

1019