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
- 10396 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 many numbers of sessions can one group in batches?
explain abt ur project architecture?
What is the commit type if you have a transaction control transformation in the mapping?
How union transformation is used?
What is a connected transformation?
On which transformations you created partitions in your project?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What do mean by local and global repository?
what is Active lock explain
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is informatica powercenter repository?
What is blocking transformation?
Differentiate between reusable transformation and mapplet.
What is the difference between stop and abort in informatica
