find out the second highest salary?
Answer Posted / anand
SELECT SALARY FROM (SELECT SALARY FROM emp WHERE ROWNUM < 3
ORDER
BY salary) WHERE ROWNUM < 2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is oracle the best database?
11. Display the client number and name and the client number and name of the person who referred that client.
What are the limitations oracle database 10g xe?
What is the difference between translate and replace in oracle?
How to filter out duplications in the returning rows using oracle?
What are the predefined tablespaces in a database?
What are the restrictions in a oracle read only transaction?
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.
What is dynamic proxy?
What is the difference between translate and replace?
What is integrity and what is constraint??Explain with example
How to drop an existing view in oracle?
What is tns service name?
What are the system predefined user roles?
How to run create database statement?