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
- 8490 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapna
select top(2) sal from emp where sal order by desc
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What are the differences between char and varchar2 in oracle?
what is meant by magic query
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How do we create privileges in oracle?
What is meant by joins? List out the types of joins.
Explain cascading triggers.
How can we find out the current date and time in oracle?
Explain enable novalidate constraint.
What is the simplest tool to run commands on oracle servers?
Does oracle charge for java?
How to check your oracle database 10g xe installation?
How to create an oracle database manually?
What are the system predefined user roles?
What is index in Oracle?
What is a private synonym?
