读书人

oracle查询话语的临时表不需要quot;ASamp;quo

发布时间: 2012-09-27 11:11:17 作者: rapoo

oracle查询语句的临时表不需要"AS"
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

读书人网 >其他数据库

热点推荐