On Tue, Dec 2, 2014 at 11:51 AM, Richard Hipp <d...@sqlite.org> wrote:
> On Tue, Dec 2, 2014 at 12:46 PM, Paul Sanderson < > sandersonforens...@gmail.com> wrote: > > > I have a query that returns one column but a number of rows so for > instance > > > > SELECT name from tab > > > > might return > > > > a > > b > > c > > d > > > > I would like to append these terms and get a single line/string > > > > a_b_c_d > > > > > > I want to just use a single SQL query to do this, is it possible? > > > > SELECT group_concat(name,'_') FROM tab; > Just a bit curious, but is there a way to ensure a particular order on the "name" column values? I.e. isn't it possible that the result might be a_d_b_c under some circumstance? > > -- > D. Richard Hipp > d...@sqlite.org > > -- The temperature of the aqueous content of an unremittingly ogled culinary vessel will not achieve 100 degrees on the Celsius scale. Maranatha! <>< John McKown _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
