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
- 8393 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
What are the varoius components of physical database structure of oracle database?
Explain cascading triggers.
How to put more than 1000 values into an oracle in clause?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Describe varray?
How to resolve name conflicts between variables and columns?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is data block in Oracle?
What is an oracle wallet?
How can I introduce multiple conditions in like operator?
What to do if dba lost the system password?
What are the common oracle dba tasks?
How to generate query output in html format?
What are the benefits of ordbms?
what is the scripts in data base?
