Thank you. It's an indirect way, and it works. Could it be the same efficient as "select group_concat(distinct data separator '-') from tst" like in mysql? I'm not quite understand the actual functionality inside, so this is significant to me.
2011/1/10 Simon Davies <[email protected]> > On 10 January 2011 14:22, smart sl <[email protected]> wrote: > > Is there any one can help? > > SQLite version 3.6.11 > Enter ".help" for instructions > sqlite> > sqlite> create table tst( data integer ); > sqlite> > sqlite> insert into tst values( 1 ); > sqlite> insert into tst values( 2 ); > sqlite> insert into tst values( 3 ); > sqlite> insert into tst values( 2 ); > sqlite> > sqlite> select group_concat( d, '-' ) from ( select distinct data d from > tst ); > 1-2-3 > sqlite> > > > > > 2011/1/7 smart sl <[email protected]> > > > >> In "Aggregate Functions" of SQLite Docs, it's said that: > >> In any aggregate function that takes a single argument, that argument > can > >> be preceded by the keyword DISTINCT. > >> > >> Then how about two arguments circumstance when I want to use distinct > and > >> together with specified separator. Is there a way to do that? > >> > >> I'm using SQLite 3.7.3 in tcl. Thanks advance. > >> > > Regards, > Simon > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
