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
- 12598 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / chanakya
SELECT CITY,
SUM(DECODE(GENDER,'MALE',NO)) MALE ,
SUM(DECODE(GENDER,'FEMALE',NO)) FEMALE
FROM TABLE_NAME GROUP BY CITY
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
Explain the different lookup methods used in informatica?
Explain Dataware house architecture .how data flow from intial to end?
Differentiate between Load Manager and DTM?
What is the meaning of up gradation of repository?
How to partition the Session?
How to differentiate between the active and passive transformations?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the benefit of partitioning a session?
Explain pmcmd command usage in informatica
What are the different transaction levels available in transaction control transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Write the advantages of partitioning a session?
what is index?how it can work in informatica
tell me the rules and responsblites in our project(my project is development)
is it possible to index the data in cache of lkp transformation ?
