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
- 10558 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / priyank
select (case when sal is null then (select min(sal) from
emp) end) from emp
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Which development components of informatica have the highest usage?
What are the new features of informatica 9.x developer?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the transformations that are not supported in mapplet?
what are the deliverables?in your project?
What differs when we choose the sorted input for aggregator transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is meant by incremental aggregation?
Is it possible to create multiple domains on a single Informatica server?
Why filter transformation is an active one?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is a filter transformation and why it is an active one?
What is xml source qualifier transformation in informatica?
How to extract sap data using informatica?
