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
- 8485 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
6. Display the client name and order date for all orders using the traditional method.
please explain.. DB architecture ...
How can windows applications connect to oracle servers?
what is the difference between substr and instr function in oracle?
How can we force the database to use the user specified rollback segment?
State and explain the different types of data models?
What is an oracle database table?
Can we connect to ORACLE db using Windows Authentication?
How to upsert (update or insert into a table)?
How to create a new user account in oracle?
How to increment dates by 1 in oracle?
Is there a combination of "like" and "in" in sql?
What are the built-in functions used for sending Parameters to forms ?
IS it possible to built the oracle database without setting the kernal parameters?
How to recover a dropped table in oracle?
