Interested to Buy Any Domain ? << Click Here >> for more details...
If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?
Advance Thanks
- 7 Answers
- 10522 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / ramesh 9866930212
select min(decode(sal,null,(select min(sal) from emp))) sal
from emp group by empno;
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How does the aggregator transformation handle null values?
Enlist some properties of sessions.
How we can create indexes after completing the load process?
Performance tuning( what you did in performance tuning)
What are the different transaction levels available in transaction control transformation?
Why union transformation is an active transformation?
How to join three sources using joiner? Explain though mapping flow.
How to handle decimal places while importing a flatfile into informatica?
How to start a workflow using pmcmd command?
What are roles and groups and benefits of using them?
What is intricate mapping?
What could be the possible resons of locks by user?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
can anyone explain me about retail domain project in informatica?
How to extract the informatica rejected data?
