boluor commented on issue #3487: URL: https://github.com/apache/doris-website/issues/3487#issuecomment-4523869015
Thanks for the report — you're right that the basic syntax line wasn't enough on its own. Submitted #3744 to backport the two `ORDER BY` examples that current/4.x already carries — into the 2.1 and 3.x docs (EN + zh): ```sql SELECT GROUP_CONCAT(value ORDER BY value DESC) FROM test; -- "c, c, b, a" SELECT GROUP_CONCAT(DISTINCT value ORDER BY value DESC) FROM test; -- "c, b, a" ``` One nuance: the `DISTINCT` + `ORDER BY` combination shipped in apache/doris#38080 (`dev/2.1.6-merged, dev/3.0.2-merged`), so it only works on **2.1.6+** and **3.0.2+**. The PR adds an inline note above that example so readers on older patch releases don't get surprised. The plain `ORDER BY` form (first example) has worked since the 2.x line. Appreciate you flagging it! -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
