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

city gender no
chennai male 40
chennai female 35
bangalore male 25
bangalore female 25
mumbai female 15

i want the required output

city male female
chennai 40 35
bangalore 25 25
mumbai 15

Answer Posted / venu

select* from tablename

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain pushdown optimization and types in informatica

1122


How to start a workflow using pmcmd command?

1306


Explain sql transformation in script mode examples in informatica

1210


Global and Local shortcuts. Advantages.

2088


What is the way to execute pl/sql script using informatica mapping?

1681


Performance tuning in UNIX for informatica mappings?

2623


in reporting we add some new objects,how we get the count of the newly added objects to the report

2249


what are the deliverables?in your project?

2194


What are the features of complex mapping?

1205


In which transformation you cannot drag ports into it?

1378


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9897


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2779


Design a mapping to load a target table with the following values from the above source?

1394


What you know about transaction control transformation?

1055


Explain dynamic target flat file name generation in informatica

1109