This is the nth max SELECT salary FROM (SELECT ROWNUM sl, salary

how to find the second highest salary in a given table????

Question Posted / manikandan. s

Answer Posted / manikandan. s

This is the nth max

SELECT salary
FROM (SELECT ROWNUM sl, salary
FROM (SELECT salary
FROM employees
GROUP BY salary
ORDER BY salary))
WHERE sl = n

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain the use of inctype option in exp command.

978

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

958

How to define a cusotmer as a supplier in ORACLE R12

2170

What is oracle database 10g express edition?

1075

How to pass parameters to procedures?

975

What is the difference between postgresql and oracle?

980

Explain the truncate in oracle?

914

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2294

What is tns entry?

1060

How to manage transaction isolation level?

951

Is truncate autocommit in oracle?

1025

What is rowid and rownum in oracle?

955

How to retrieve data from an cursor to a record?

1019

What is a trace file and how is it created in oracle?

974

What are the execution control statements?

1018