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 / 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
How to handle decimal places while importing a flatfile into informatica?
Explain the types of lookup transformation?
What is flashback table ? Advance thanks
What could be the possible resons of locks by user?
What is incremental aggregation?
How many ways a relational source definition can be updated and what are they?
What is the scenario which compels informatica server to reject files?
What are batches?
How to use pmcmd utility command?
Explain direct and indirect flat file loading (source file type) - informatica
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is joiner change?
What does “tail –f” command do and what is its use as an Informatica admin.
How many types of sessions are there in informatica.please explain them?
Which transformation is needed while using the Cobol sources as source definitions?