Oracle中wm_concat()的使用方法

最新推荐文章于 2022-08-28 14:11:17 发布

weixin_30609331

最新推荐文章于 2022-08-28 14:11:17 发布

阅读量960

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/wala-wo/p/5119276.html

本文介绍了wm_concat函数的两种使用方法：一是通过窗口函数实现，二是利用GROUP BY进行聚合。这两种方式均可实现在指定分组条件下对某一字段值进行拼接。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

以下两种方式使用wm_concat()的使用方法是等效的。

方法一：使用窗口函数，wm_concat支持窗口函数

select distinct classKey,className, classOrder, weekDayKey, lessonkey, lessonName, lessonType,
    wm_concat(subjectkey) over(partition by classKey,className, classOrder, weekDaykey, lessonkey, lessonName,lessonType),
    wm_concat(subjectName)  over(partition by classKey,className, classOrder, weekDaykey, lessonkey, lessonName,lessonType)
from VW_CLASSCourseTable
Where schoolKey = P_SchoolKey
And gradeKey = P_GradeKey
And termKey = P_TermKey
order by classOrder asc, weekDaykey asc, lessonType asc

方法二：使用group by方式

select classKey,className, classOrder, weekDaykey, lessonkey, lessonName, lessonType,
    wm_concat(subjectkey),
    wm_concat(subjectName)
from VW_CLASSCourseTable
Where schoolKey = P_SchoolKey
And gradeKey = P_GradeKey
And termKey = P_TermKey
group by classKey,className, classOrder, weekDaykey, lessonkey, lessonName,lessonType
order by classOrder asc, weekDaykey asc, lessonType asc ;

转载于:https://www.cnblogs.com/wala-wo/p/5119276.html