how to find the second highest salary in a given table????
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 |
Post New Answer View All Answers
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How to use subqueries with the in operator using oracle?
Explain an extent?
What are triggers in oracle?
Can select statements be used on views in oracle?
How do you store pictures in a database?
What privilege is needed for a user to connect to oracle server?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What are the extensions used by oracle reports?
can u plz provide me oca sql dumps please i need them
How to convert characters to times in oracle?
How to view the data files in the current database?
What is a dead lock in oracle?
How to create lov dynamically at runtime & attach to text field?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.