In my sourse i have like
ename,gender
vasu,male
geetha,female
ram,male
suma.female
kesav,male

in my output i need
male,female
vasu,geetha
ram,suma
kesav

Answer Posted / suri

Write the condition based on the gender . so that all males
comes one side and females come another side

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is size of u r database?

1852


Parameter and variable differences

1622


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4793


What are the components of workflow manager?

590


can u any challenge your project?

1612






can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2142


What are the new features of informatica 9.x at the developer level?

609


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1453


How identifying bottlenecks in various components of informatica and resolving them?

587


Define the various join types of joiner transformation?

561


Where do we use mapping variables in informatica?

621


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1563


Define enterprise data warehousing?

637


How to partition the Session?

648


How can we store previous session logs?

572