1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.
Answer Posted / hema
Select sal from emp a where 2=(select count(distinct sal)
from emp b where a.sal <= b.sal)
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to join two tables in a single query using oracle?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
Explain the use of indexes option in exp command.
How to sort output in descending order in oracle?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What are the different types of synonyms?
Explain the blob datatype?
What do you mean by a deadlock?
How to build data dictionary view an new database?
Explain what are the type of synonyms?
What are the extensions used by oracle reports?
Explain the use of ignore option in imp command.
What does sharding mean?
what is the difference between restoring and recovering?
What is a dynamic performance view in oracle?