How to display multiple rows data in single row
Posted: Fri Jul 02, 2010 8:48 am
HI,
I have the data with two columns with two rows as follows.
IS_AVAILABLE_SRDR SRDR_COUNT
X 5
Y 6
The output required as follows.
IS_AVAILABLE_SRDR SRDR_COUNT IS_AVAILABLE_SRDR SRDR_COUNT
X 5 Y 6
How to get the above output.
Thanks,
I have the data with two columns with two rows as follows.
IS_AVAILABLE_SRDR SRDR_COUNT
X 5
Y 6
The output required as follows.
IS_AVAILABLE_SRDR SRDR_COUNT IS_AVAILABLE_SRDR SRDR_COUNT
X 5 Y 6
How to get the above output.
Thanks,