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 is the difference between translate and replace in oracle?

648

What is different types of joins?

570

Write a trigger example in oracle?

570

What is the difference between hot backup and cold backup in oracle?

520

What is concurrency in oracle?

540

How to pass parameters to procedures in oracle?

566

What is the string concatenation operator in oracle?

567

Explain about your project and its relation to the current job position you are applying to?

538

how to join query for one source type is oracle another source type is sql server ?

1986

What is oracle thin client?

531

Explain oracle instance.

680

How do you tell what your machine name is and what is its IP address?

1513

How many categories of data types?

570

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1618

How to view the data files in the current database?

592