Hi,
I am trying to achieve the following using sql in oracle
table "xxx"
namevalue
a 1
a 2
a 3
b 4
b 5
select name, (string concat of values ie 1,2,3)
from xxx
where name in('a','b')
Resulting in
a 123
b 45
I am trying to achieve the following using sql in oracle
table "xxx"
namevalue
a 1
a 2
a 3
b 4
b 5
select name, (string concat of values ie 1,2,3)
from xxx
where name in('a','b')
Resulting in
a 123
b 45