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
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
