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 0:25am
Edited 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
0 Sergey Alexandrovich Kryukov 499
1 Nirav Prabtani 298
2 OriginalGriff 215
3 _Amy 165
4 Abhinav S 160
0 OriginalGriff 7,755
1 Sergey Alexandrovich Kryukov 6,951
2 Maciej Los 3,994
3 Peter Leow 3,698
4 CHill60 2,742


Advertise | Privacy | Mobile
Web03 | 2.8.140721.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