select * from city pivot(max(no) for gender in('male ','fema

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 / anshita gupta

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

Answer Posted / anshita gupta

select * from city pivot(max(no) for gender in('male ','female'));

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Tell me about MD5 functions in informatica

880

what is diff b/t sorter t/r and agg have the option sorter property...

2136

What is decode in informatica?

1075

What do you understand by term role-playing dimension?

986

What is rank index in rank transformation?

1013

How do we call shell scripts from informatica?

1016

can anyone suggest best free Talend data integration training online

1629

What do you understand by a term domain?

1066

How many ways are there to do 'remove duplicate records in informatica'?

958

How to elaborate powercenter integration service?

1076

What is session task and command task?

1183

expain about the tune parameters?

2342

What is sorter transformation?

984

Differentiate between source qualifier and filter transformation?

1511

What is the format of informatica objects in a repository?

977