Click here to Skip to main content
12,953,007 members (35,858 online)
Rate this:
 
Please Sign up or sign in to vote.
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]
Posted 13-Jan-11 0:25am
Updated 13-Jan-11 0:50am
v2

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

You already got an answer on sqlite.org :
http://www.sqlite.org/lang_aggfunc.html#groupconcat[^]

Cheers
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,389
CHill60 3,490
Maciej Los 3,103
Jochen Arndt 1,975
ppolymorphe 1,920


Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 13 Jan 2011
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100