If I have a select statment which retrives 2 rows, & that rows have the sa

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

Question Posted / meldo

2 Answers
3919 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If I have a select statment which retrives 2 rows, & that rows have the same data in all the f..

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

If I have a select statment which retrives 2 rows, & that rows have the same data in all the f..

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

Post New Answer