select* from tablename

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

Question Posted / venu

5 Answers
12820 Views
Tech Mahindra, I also Faced
E-Mail Answers

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

What is joiner transformation in informatica?

1045

how to load rows into fact table in data warehouse

1190

Explain sessions?

1064

How do you use reject loader.

2603

In which transformation you cannot drag ports into it?

1320

What is complex mapping?

1120

what are the Methods For Creating Reusable Transformations?

1173

Under which circumstances, informatica server creates reject files?

1095

Explain the difference between a data warehouse and a data mart?

1056

COM components can be used in Informatica

2390

What are roles and groups and benefits of using them?

1057

Make a note of the quantity vaults made in informatica?

988

Explain what are the different versions of informatica?

1097

What are the components of the workflow manager?

1135

Explain lookup transformation is active in informatica

1104