On Feb 3, 2014, at 11:05 PM, big stone <stonebi...@gmail.com> wrote:
> group_concat is indeed super nice ! I didn't notice that little jewel of > SQLite, thank you. You are welcome. But *do* read the very fine prints associated with that aggregate function: http://www.sqlite.org/lang_aggfunc.html “… The order of the concatenated elements is arbitrary… “ … which, well, renders it pretty much useless for anything but display purpose… and even then… sigh... > Is there a "standardized" SQL normalization for that ? No. Not that I know of. > (I see that oracle has a LISTAGG instead) Yes, LISTAGG [1] is much more usable in that respect as it sports a WITHIN GROUP ( ORDER BY … ) clause which makes is more predictable. [1] http://docs.oracle.com/cd/E11882_01/server.112/e17118/functions089.htm _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
