If I have a select statment which retrives 2 rows, & that
rows have the same data in all the fields except the last
field and I want to merge the 2 rows to be in 1 row with
concatenating the last field which have the different
data.... eg: the 1st row has these fields: A-B-C
the second row has: A-B-X ........ i want to merge the two
row to be in one row like ----> A- B- C,X
Answers were Sorted based on User's Feedback
Answer / murali mohan
Try this...Hope this will give the Required Answer
create table testsamp(a char,b char,c char);
insert into testsamp values ('A','B','C');
insert into testsamp values ('A','B','X');
select a,b,c from(
select a , b,
c||lead(c,1) over (partition by a,b order by a,b) c from
testsamp ) tmp where rownum=1;
Regards,
Murali
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / sreeharibabu g
select max(a),max(b),listagg(c,',') within group ( order by null) from testsamp group by a,b;
Is This Answer Correct ? | 0 Yes | 0 No |
What is meant by redo log buffer ?
What are the different approaches used by Optimizer in choosing an execution plan ?
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
What are various constraints used in SQL?
what are the things that you consider while creating indexes on partitioning tables?
Can we store pictures in the database and if so, how it can be done?
what is the difference between rollback & commit? can a foreign key has null value?
what are the differen between key flexifild and discriptive fiexifild.
what is the syntax of update command?
What is a subquery?
What is the maximum limit on the number of columns in a table?
what is null value?