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
- 5 Answers
- 12750 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
What do you understand by SOA of Informatica?
what is the difference between informatica6.1 and infomatica7.1
Explain informatica architecture - version 8 / 9
How does a rank transform differ from aggregator transform functions max and min?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How to improve the performance of a session using sorter transformation?
What are junk dimensions?
In warehouses how many schemas are there?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are the components of workflow manager?
can we override a native sql query within informatica? How do we do it?
Define Pmrep command?
In informatics server which files are created during the session rums?
What is workflow manager?
Explain how to import oracle sequence into informatica?
