表:TEST
外键:F_ID
需要排序字段:SORT
- 先对表相关字段进行排序,然后再WMCANCAT
SELECT WM_CONCAT(SORT) FROM
( SELECT F_ID,SORT FROM TEST ORDER BY F_ID ,SORT ) T
- 使用视窗函数(百度一大堆)
SELECT F_ID,MAX(C_SORT) FROM
(SELECT F_ID,
WM_CONCAT(SORT) OVER (PARTITION BY F_ID ORDER BY SORT) C_SORT
FROM TEST)
GROUP BY F_ID