If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?
Advance Thanks
- 7 Answers
- 9218 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
what is the size of your data warehousing?
How do you migrate data from one environment to another?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Suppose we do not group by on any ports of the aggregator what will be the output?
Explain dynamic target flat file name generation in informatica
Explain sessions. Explain how batches are used to combine executions?
What is the difference between Active and Passive transformation?
What is decode in static cache?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is enterprise data warehousing?
Design a mapping to load the cumulative sum of salaries of employees into target table?
what is SDLC way of code development?
What is a passive transformation?
How do you set a varible in incremental aggregation
What is an Integration service in Informatica?
