wtite sql query following table are
city gender no
chennai male 40
chennai female 35
bangalore male 10
bangalore female 25
mumbai female 15
i want the output?
city male female
chennai 40 35
bangalore 10 25
mumbai null 15
Answer Posted / santosh kumar sarangi
select city,max(decode(gender,'male',no)) as male,
max(decode(gender,'female',no)) as female from table_name
group by city
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How to generate sequence numbers?
What will be the approach?
What is a transaction control transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Can you use flat files in Mapplets.
What do you mean by worklet?
What is the surrogate key?
Make a note of the quantity vaults made in informatica?
Different qualification between a related rotate toward the sky and isolates look upward?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
pmscmd startworkflow -sv
What is a sorter transformation?
What is parallel processing in informatica?
What you know about transaction control transformation?