Web Development
Web Developer From India
(Move to ...)
Home
▼
July 14, 2016
Single SQL query with GROUP_CONCAT, DISTINCT and SEPARATOR.
Here is example for use GROUP_CONCAT, DISTINCT and SEPARATOR in single sql query,
Example:
SELECT group_concat(distinct (id) SEPARATOR ', ') AS ID FROM (tablename) WHERE 1=1
Enjoy!
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment