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
- 8636 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapna
select top(1) sal From sample
where sal
in (select top(2) salfrom sample order by saldesc)
order by sal asc
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
Explain an exception and its types?
Explain the use of consistent option in exp command.
Please explain oracle data types with examples?
How to create a server parameter file?
How to check the server version in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What is blob data type in oracle?
How to create an oracle testing table?
What is an oracle data file?
What are the general rules on data consistency?
Difference between the “verify” and “feedback” command?
What is truncate oracle?
What is meant by joins? List out the types of joins.
What is sequence?
What are the varoius components of physical database structure of oracle database?
