[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] Concatenate single field from multiple records?
From:       "Igor Tandetnik" <itandetnik () mvps ! org>
Date:       2009-02-26 18:04:23
Message-ID: go6lj8$pm7$1 () ger ! gmane ! org
[Download RAW message or body]

Greg Robertson <trifusion@gmail.com>
wrote:
> Is it possible with just an SQL to Concatenate the content from
> several records of a single field with perhaps a character inbetween?
>
> For example if I have TableA that has Field1 with the following info
> in Field1:
>
> rec1:  How
> rec2:  are
> rec3:  you
> rec4:  ?
>
> Would it be possibly using only SQL to output a single field with the
> content" "How are you ?"

select group_concat(Field1, ' ') from TableA;

http://www.sqlite.org/lang_aggfunc.html

Igor Tandetnik



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]