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
- 5 Answers
- 11263 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 let me know how to make encryption and decryption with example?
Explain what are the different versions of informatica?
What are the mapping parameters and mapping variables?
Can we override a native sql query within informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to delete duplicate row using informatica?
Explain transaction control transformation in informatica
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How can we delete duplicate rows from flat files?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
State the differences between sql override and lookup override?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How can a transformation be made reusable?
How to generate sequence numbers without using the sequence generator transformation?
How can we create index after completion of load process?
