SQLite Forum

How to cancatenate all lines in table to a single string?
Your warning is technically correct. I have found that the ordering of group members to be concatenated can be determined, even while understanding that the means for doing so are outside the set theory basis of the query language. It would be comforting to see an order guarantee for the results of "order by ..." clauses in inner queries.