android - DISTINCT values with ", " divider in GROUP_CONCAT -

- 

group_concat(g_value,", ")

this gives me values [comma]+[space] divider

apple, orange, banana, apple, apple

group_concat(distinct g_value)

this gives me distinct values "," divider without space.

apple,orange,banana

how distinct values ", " divider?

apple, orange, banana

correct syntax is

group_concat( distinct g_value separator ', ')

Comments

Post a Comment

Popular posts from this blog

Using 'OR' and 'AND' in SQL Server -

-
is using ( condition or condition b , condition c ) the same as ( condition , condition c) or (condition b , condition c) no. first condition is: (condition a) or (condition b , condition c) and second is: (condition , condition c) or (condition b , condition c) you can see difference between them.
Read more

c++ - NetBeans Remote Development with additional configuration -

-
i'm trying use netbeans (7.3.1) work on remote project. my configuration following: my local machine windows 7 laptop. doesn't have tools. in particular neither compiler nor debugger. have netbeans ide , putty example. source code, make scripts , (eventually) build results located on remote storage shared across servers , "locals". (i might switch single server storage faster don't think matters @ all.) i'm accessing using sshfs manager . sshfs manager takes server name, path on server, user name , ssh private key. in result mounts directory on server disk on windows. works fine. (although directories, possibly links, represented files in windows explorer, don't know if matters...) netbeans project located on local machine don't think matters , place remotely well. prefer keep "off source" don't have add ignores version control. in netbeans did procedure described in remote developement tutorial . seems successful. netbeans c...
Read more

visual studio - TFS will not accept changes I've made to a Java project -

-
i using tfs's team explorer manage visual studio projects. recently, i've created new java project (not in visual studio) manually added tfs using source control control explorer in visual studio. after added java project tfs, made changes , bug fixes. then, went visual studio , opened source control explorer check in changes, tfs thinks no changes made. it seems needed check out project before making changes. guess erroneously expected tfs track automatically, okay. so, using source control explorer in tfs, checked out project, , tried check in pending changes. when tried check in, got following message: all of changes either unmodified files or locks. changes have been undone server. is there way convince server indeed project has changed? how can check in changes have made? thank help.
Read more