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

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1930

How to use subqueries with the in operator using oracle?

1089

Explain an extent?

1095

What are triggers in oracle?

1032

Can select statements be used on views in oracle?

1024

How do you store pictures in a database?

1001

What privilege is needed for a user to connect to oracle server?

987

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1930

What are the extensions used by oracle reports?

1033

can u plz provide me oca sql dumps please i need them

1945

How to convert characters to times in oracle?

1021

How to view the data files in the current database?

1094

What is a dead lock in oracle?

1118

How to create lov dynamically at runtime & attach to text field?

1178

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2966