Interbase SQL Select Group By Records into one row with commas

Question

I have a simple Interbase SQL Select Group By query:

Select STRINGNAME from STRINGLIST
Group by STRINGNAME

This query returns this result:

STRINGNAME
FirstString
SecondString
ThirdString

and etc.

I would like to have my query return one row that does this in any order:

FirstString,SecondString,ThirdString

or inverted

ThirdString,SecondString,FirstString

How is it possible to do it? I was thinking of a procedure but maybe there is another more simple way?

Duplicate of this http://stackoverflow.com/questions/887628/convert-multiple-rows-into-one-with-comma-as-separator — Yashveer Singh, Jan 18 '17 at 08:30
please check this answer :- http://stackoverflow.com/questions/887628/convert-multiple-rows-into-one-with-comma-as-separator — Yashveer Singh, Jan 18 '17 at 08:30
@YashveerSingh Sorry. I couldn't find it. Wasn't searching by keyword "concatenate". — SovereignSun, Jan 18 '17 at 08:34
Guys none of those work.. I think that's all for mySQL and MS SQL and not Interbase SQL or Firebird SQL! — SovereignSun, Jan 18 '17 at 08:42

score 1 · Accepted Answer · answered Jan 18 '17 at 09:01

1

I've found the answer myself. Thanks.

Firebird and Interbase have a LIST() aggregate function which does just what I need:

SELECT LIST(DISTINCT STRINGNAME, ',')
FROM STRINGLIST

This works perfectly for Interbase SQL and Firebird SQL

answered Jan 18 '17 at 09:01

SovereignSun

score 0 · Answer 2 · answered Jan 18 '17 at 09:55

0

using temp variable you can do this:-

declare @tmp varchar(max)
SET @tmp = ''
select @tmp = @tmp + STRINGNAME + ', ' from STRINGLIST Group by STRINGNAME
select @tmp

answered Jan 18 '17 at 09:55

anjali

2 Answers2