Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 6 Answers
- 8491 Views
- I also Faced
- E-Mail Answers
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
Calculate difference between 2 date / times in oracle sql?
How to export your own schema?
What is recycle bin in Oracle?
What are the various constraints used in oracle?
How to execute a stored program unit?
What is Reduced List of Values?
What is the simplest tool to run commands on oracle servers?
Explain what are clusters?
Explain the features of oracle?
How to update values on multiple rows in oracle?
What suggestions do you have to reduce the network traffic?
What do you mean by group by clause?
How to call a sub procedure?
Explain the use of log option in exp command.
How to calculate date and time differences in oracle?
