且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

MySQL:按字母顺序在多个列中获取唯一值

更新时间:2022-12-10 09:54:55

(SELECT DISTINCT colA AS color FROM table) UNION
(SELECT DISTINCT colB AS color FROM table) UNION
(SELECT DISTINCT colC AS color FROM table)
ORDER BY color