Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL2000 SQL SQL-Server Oracle , +
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 1:25am
Edited 13-Jan-11 1: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
0 OriginalGriff 400
1 Sergey Alexandrovich Kryukov 329
2 Afzaal Ahmad Zeeshan 264
3 BillWoodruff 245
4 CPallini 195
0 OriginalGriff 5,560
1 DamithSL 4,476
2 Maciej Los 3,942
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,175


Advertise | Privacy | Mobile
Web04 | 2.8.141216.1 | Last Updated 13 Jan 2011
Copyright © CodeProject, 1999-2014
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