I tried this, of course, before asking, but: group_concat(distinct(t.LastName || ', ' || t.FirstName), '; ') As Teachers, gives [15:19:32] Error while executing SQL query on database 'test': DISTINCT aggregates must have exactly one argument
> To: sqlite-users at mailinglists.sqlite.org > From: rsmith at rsweb.co.za > Date: Thu, 8 Oct 2015 23:58:09 +0200 > Subject: Re: [sqlite] Can this be done in SQLite? > > > > On 2015-10-08 11:47 PM, K. P. wrote: > > Am using SQLiteStudio - which I really like - though I have wondered if it > > passes all its knowledge around errors onto the user... > > I hope it does. Try some other ones too, just to get a wider idea. > Perhaps http://www.sqlc.rifin.co.za/ or http://www.sqliteexpert.com/ if > on Windows, or https://github.com/sqlitebrowser/sqlitebrowser if on > Linux/Mac. If any of them do things that seem odd, and you are > comfortable using command line tools, the sqlite3 CLI is best for > checking/testing SQL at http://www.sqlite.org/download.html > > As to your distinct question, sure, use like this: > > SELECT group_concat(DISTINCT fullName) FROM sometable WHERE 1; > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
