Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



write sql query following table pname description lux soap sunsilk shampoo lux shamp..

Answer / vijaya

by using Deocde or case expression get the above o/p

Is This Answer Correct ?    6 Yes 2 No

Post New Answer

More Informatica Interview Questions

What are the parts of Informatica Server?

1 Answers   Cognizant,


plz plz plz send client names and project names in informatica?

1 Answers  


what is metadata?

6 Answers  


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

0 Answers  


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

1 Answers   TCS,


Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  


when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  


How will u pas the data with out debugger?

4 Answers  


Is it possible to define a single node as a Gateway node as well as worker node?

0 Answers  


replace multiple spaces with single space.

3 Answers   IBM,


How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?

2 Answers   Rolta,


how do the project develops? pls specify right from the start to end in step by steps.

0 Answers   ITC Infotech,


Categories