如何在oracle sql中转置和枢轴

Question

我正试图从表中翻转数据，这里是一个屏幕截图来解释它的外观。左边是数据库表右边是如何推导它

到目前为止，我已经尝试使用pivot和case语句，但无法获得我需要的视图，请指导

Answer 1

这通常是在表示层而不是在数据库中执行的任务。

---

如果你必须在SQL中做，那么你可以使用:

SELECT *
FROM   shift_t
PIVOT (
MAX(shift)
FOR shift_date IN (
DATE '2022-07-01' AS "07/01/2022",
DATE '2022-07-02' AS "07/02/2022",
DATE '2022-07-03' AS "07/03/2022",
DATE '2022-07-04' AS "07/04/2022",
DATE '2022-07-05' AS "07/05/2022",
DATE '2022-07-06' AS "07/06/2022",
DATE '2022-07-07' AS "07/07/2022",
DATE '2022-07-08' AS "07/08/2022",
DATE '2022-07-09' AS "07/09/2022"
)
)

对于样本数据，输出:

07/09/2022W