Re: database help
Ok sorry
SELECT person, group_concat( concat( date, ' ',
COMMENT ))
FROM test
GROUP BY person
worked but
group_concat( concat( date, ' ', COMMENT )) is holding 2016-02-14 comment1,2016-02-20 comment3
I want one column for each ex... How can I get that?
person- date1------ comment1----- date2-------comment2
person1 2016-02-14 Comment1 2016-02-20 Comment3
person2 2016-02-14 Comment2 2016-02-20 Comment4
Subject
Written By
Posted
February 08, 2016 10:43AM
February 08, 2016 11:07AM
February 08, 2016 12:17PM
February 08, 2016 01:17PM
Re: database help
February 08, 2016 02:01PM
February 08, 2016 03:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.