On 13 January 2011 07:34, amna shahzad <amna.shahzad...@gmail.com> wrote:
> i have a countries table
> create table countries ( country_name varchar2 (100));
>
> add some records
>
> insert into countries values ('Albania');
> insert into countries values ('Andorra');
> insert into countries values ('Antigua');
>
> query for concatenate records
>
> SELECT SUBSTR (SYS_CONNECT_BY_PATH (country_name , ','), 2) csv
> FROM (SELECT country_name , ROW_NUMBER () OVER (ORDER BY country_name
> ) rn, COUNT (*) OVER () cnt FROM countries) WHERE rn = cnt START
> WITH rn = 1 CONNECT BY rn = PRIOR rn +1;CSV
>
> and result is
>
> Albania,Andorra,Antigua
>
> this query works on oracle database..but i does not work on SQLITE
>
> please explain me
> How can I combine multiple rows into a comma-delimited list in SQLITE
http://www.sqlite.org/lang_aggfunc.html#groupconcat
Regards,
Simon
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
