本文深入探讨了如何使用SQL查询选择特定订单的例外时间，具体通过使用SELECT语句配合GROUP BY和子查询来实现。通过实例演示，帮助读者掌握高级SQL查询技能。
SELECT except_time
FROM
(SELECT MIN(except_time) as except_time,
normal_order_no
FROM KL_PRODPLAN_OPERATION_ORDER
WHERE normal_order_no IN ('HL11070009','HL11080004')
AND except_time IS NOT NULL
GROUP BY normal_order_no
) temp_table2 --这里，不需要用 AS temp_table2
FROM
(SELECT MIN(except_time) as except_time,
normal_order_no
FROM KL_PRODPLAN_OPERATION_ORDER
WHERE normal_order_no IN ('HL11070009','HL11080004')
AND except_time IS NOT NULL
GROUP BY normal_order_no
) temp_table2 --这里，不需要用 AS temp_table2
扫一扫
3542
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
