concatenate record in SQLite

See more:

SQL-server-2000

SQL

SQL-Server

, +

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

[Edit]Code is wrapped in "pre" tags[/Edit]