hana sql query

[former_member685433]

Hi experts,

I want to query some data and put it in the same row.

for ex. I have sales orders number 1 to 5 I want to put them in the same cell as that (1,2,3,4,5)

is that possible?

[KonradZaleski · Accepted solution]

You can use STRING_AGG function to concatenate values. Here is an example:

CREATE LOCAL TEMPORARY TABLE #t1 ("ORDER" VARCHAR(10));

INSERT INTO  #t1 VALUES ('1');
INSERT INTO  #t1 VALUES ('2');
INSERT INTO  #t1 VALUES ('3');
INSERT INTO  #t1 VALUES ('4');
INSERT INTO  #t1 VALUES ('5');

SELECT STRING_AGG("ORDER",',') FROM #t1;

[former_member685433]

Thank's Konrad STRING_AGG works with me

[KonradZaleski]

Then please accept the answer.