ORA-00913: too many values

[floatingabc]

SQL> SELECT MIN(p_retailprice), MAX(p_retailprice)
FROM PART LEFT JOIN LINEITEM ON PART.P_PARTKEY=LINEITEM.L_LINENUMBER
WHERE L_PARTKEY NOT IN
(SELECT MAX(L_DISCOUNT),MIN(L_EXTENDEDPRICE)
FROM LINEITEM
WHERE L_QUANTITY <200); 2 3 4 5 6
(SELECT MAX(L_DISCOUNT),MIN(L_EXTENDEDPRICE)
*
ERROR at line 4:
ORA-00913: too many values
这个错误要怎么改呢，谢谢大家！

[Dave]

SELECT MIN(p_retailprice), MAX(p_retailprice)
FROM PART LEFT JOIN LINEITEM ON PART.P_PARTKEY=LINEITEM.L_LINENUMBER
WHERE L_PARTKEY NOT IN -- 这里是一个字段
(SELECT MAX(L_DISCOUNT),MIN(L_EXTENDEDPRICE) -- 这里select的结果是2个值，与前面的不匹配
FROM LINEITEM
WHERE L_QUANTITY <200);

提示比较明显
ORA-00913: too many values



------------------------------------------------------------------------------
Blog： http://blog.csdn.net/tianlesoftware
网上资源： http://tianlesoftware.download.csdn.net
相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群：62697716(满); DBA2 群：62697977(满)
DBA3 群：63306533; 聊天 群：40132017

[floatingabc]

[Quote=引用 1 楼 tianlesoftware 的回复:]
SELECT MIN(p_retailprice), MAX(p_retailprice)
FROM PART LEFT JOIN LINEITEM ON PART.P_PARTKEY=LINEITEM.L_LINENUMBER
WHERE L_PARTKEY NOT IN -- 这里是一个字段
(SELECT MAX(L_DISCOUNT),MIN(L_EXTENDEDPRI……
[/Quote]
多谢帮助！