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
What is a oracle database?
What is a table index in oracle?
What is using clause and give example?
What is a nvl function?
How to create a new table in oracle?
How to write numeric literals in oracle?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
What is difference between cartesian join and cross join?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to establish administrator authentication to the server?
What is the meaning of recursive hints in oracle?
How can I get column names from a table in oracle?
 How to use an oracle sequence generator in a mapping?
List the parts of a database trigger.
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?