On Feb 3, 2014, at 10:11 PM, big stone <[email protected]> wrote:
> bag colors bag1 blue - red - yellow bag2 green - yellow
Does that really require a recursive query? Wouldn’t a simple group by +
group_concat do as well?
with
DataSet
as
(
select 'bag1' as bag, 'blue' as color union all
select 'bag1' as bag, 'red' as color union all
select 'bag1' as bag, 'yellow' as color union all
select 'bag2' as bag, 'green' as color union all
select 'bag2' as bag, 'yellow' as color
)
select DataSet.bag as bag,
group_concat( DataSet.color, ' - ' ) as colors
from DataSet
group by DataSet.bag
order by DataSet.bag;
P.S.
I’m starting to develop a strong aversion to that ‘values( … )’ syntax… sigh...
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
