如何将列中的特定行聚合到数组中？

发布于 2025-01-11 15:35:32 字数 350 浏览 0 评论 0原文

我有这样的表

| work_order_id | part_number | due_date   |
|: 1            |:P123:       | 2022-03-04:|
|: 2            |:P123:       | 2022-03-11:|
|: 3            |:P123:       | 2022-04-02:|

本质上我想创建一个视图，其中第一行和第三行按第二列的顺序聚合。所以结果视图应该如下所示：

|: {1,2,3}|:P123:| {2022-04-2, 2022-03-11, 2022-04-2:|

原文

I have table such as

| work_order_id | part_number | due_date   |
|: 1            |:P123:       | 2022-03-04:|
|: 2            |:P123:       | 2022-03-11:|
|: 3            |:P123:       | 2022-04-02:|

Essentially I wanted to create a view where the first and third rows are aggregated by the order of the second column. So the resulting view should look like:

|: {1,2,3}|:P123:| {2022-04-2, 2022-03-11, 2022-04-2:|

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

木槿暧夏七纪年 2025-01-18 15:35:32

聚合函数 ARRAY_AGG() 似乎就是您所追求的。

SELECT ARRAY_AGG(work_order_ID ORDER BY work_order_ID) as WorkorderIDs
     , part_number
     , ARRAY_AGG(due_Date ORDER BY work_order_ID) as due_dates
FROM yourTableName
GROUP BY part_number

The Aggregrate function ARRAY_AGG() seems to be what you're after.

SELECT ARRAY_AGG(work_order_ID ORDER BY work_order_ID) as WorkorderIDs
     , part_number
     , ARRAY_AGG(due_Date ORDER BY work_order_ID) as due_dates
FROM yourTableName
GROUP BY part_number

回复收藏 0 原文

~没有更多了~