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
