티스토리 뷰

공부

[SQL] SELECT GROUP_CONCAT(DISTINCT categories ORDER BY categories ASC SEPARATOR ' ') FROM table

승가비 2024. 9. 5. 20:08
728x90
SELECT GROUP_CONCAT(DISTINCT categories ORDER BY categories ASC SEPARATOR ' ') FROM table
 

https://stackoverflow.com/questions/3083499/mysql-distinct-on-a-group-concat

 

MySQL DISTINCT on a GROUP_CONCAT()

I am doing SELECT GROUP_CONCAT(categories SEPARATOR ' ') FROM table. Sample data below: categories ---------- test1 test2 test3 test4 test1 test3 test1 test3 However, I am getting test1 test2 test3

stackoverflow.com

 

728x90
저작자표시 비영리

'공부' 카테고리의 다른 글

[linux] rsync  (0) 2024.09.12
[spring] JPA @Enumerated(value = EnumType.STRING) @Column  (0) 2024.09.05
[kotlin] validation @field:xxx  (0) 2024.09.05
[spring] collections validation @Validated(class) @Valid(List<@Valid Object>)  (0) 2024.09.05
[nginx] sudo nginx -s stop  (0) 2024.09.05
댓글