write sql query following table
pname description
lux soap
sunsilk shampoo
lux shampoo
sunsilk soap
clouseup soap
closeup paste
i want the output like
pname description
lux soap
sunsilk shampoo
lux soap
sunsilk shampoo
closeup paste
closeup paste
Answer / vijaya
by using Deocde or case expression get the above o/p
| Is This Answer Correct ? | 6 Yes | 2 No |
What are the parts of Informatica Server?
plz plz plz send client names and project names in informatica?
what is metadata?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
How will u pas the data with out debugger?
Is it possible to define a single node as a Gateway node as well as worker node?
replace multiple spaces with single space.
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
how do the project develops? pls specify right from the start to end in step by steps.