本文介绍了一个复杂的SQL查询案例，使用了数据透视技术来从HR_ATTENDANCE_MANAGEMENT_FUNPIVOT函数中获取特定ORDERID的工作类型和工作时间数据。此查询涉及大量时间点的指定，并对历史记录进行过滤。
SELECT
ORDERID,
NAME,
ID,
WORK_TYPE,
WORK_TIME
FROM
HR_ATTENDANCE_MANAGEMENT_F UNPIVOT (
WORK_TYPE FOR WORK_TIME IN (
TWENTYSEVEN,
TWENTYEITHT,
TWENTYNINE,
THIRTY,
THIRTYONE,
ONE,
TWO,
THREE,
FOUR,
FIVE,
SIX,
SEVEN,
EIGHT,
NINE,
TEN,
ELEVEN,
TWELVE,
THIRTEEN,
FOURTEEN,
FIVETEEN,
SIXTEEN,
SEVENTEEN,
EIGHTEEN,
NINETEEN,
TWENTY,
TWENTYONE,
TWENTYTWO,
TWENTYTHREE,
TWENTYFOUR,
TWENTYFIVE,
TWENTYSIX
)
)
WHERE
ORDERID ='521001180605100059952'
AND
HISTORY='0'
扫一扫
09-01
9553
9553
08-11
3535
3535
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
