去重复报ORA-00913: too many values 。。。

[l_dongdong]

--DELETE PRICE_INFO_TBL

select * from PRICE_INFO_TBL
WHERE (PROD_SID,PRICE_BOOK_SID,CREATOR) IN
(
select PROD_SID,PRICE_BOOK_SID,CREATOR,count(*) from PRICE_INFO_TBL group by PROD_SID,PRICE_BOOK_SID,PROJECT_SID,CREATOR having count(*) >1
and PROJECT_SID = 10 and PRICE_BOOK_SID = 33 and CREATOR LIKE '0005546904%'
) AND ROWID NOT IN (
SELECT MIN(ROWID) FROM PRICE_INFO_TBL GROUP BY PROD_SID,PRICE_BOOK_SID,PROJECT_SID,CREATOR HAVING COUNT(*) > 1 and PROJECT_SID = 10
and PRICE_BOOK_SID = 33 and CREATOR LIKE '0005546904%'
)

请问为什么会报
ORA-00913: too many values 错误呢

我想删除 表 PRICE_INFO_TBL
中
PRICE_BOOK_SID = 33 CREATOR 和LIKE '0005546904%'的 筛选结果 并且


PROD_SID,PRICE_BOOK_SID,CREATOR 这三个字段重复的记录



谢谢！@

[tangren]

下面两处红色部分，也就是in的列数要对应，一样多，可以把count(*)去掉
select * from PRICE_INFO_TBL
WHERE (PROD_SID,PRICE_BOOK_SID,CREATOR) IN
(
select PROD_SID,PRICE_BOOK_SID,CREATOR,count(*) from PRICE_INFO_TBL group by PROD_SID,PRICE_BOOK_SID,PROJECT_SID,CREATOR having count(*) >1
and PROJECT_SID = 10 and PRICE_BOOK_SID = 33 and CREATOR LIKE '0005546904%'
) AND ROWID NOT IN (
SELECT MIN(ROWID) FROM PRICE_INFO_TBL GROUP BY PROD_SID,PRICE_BOOK_SID,PROJECT_SID,CREATOR HAVING COUNT(*) > 1 and PROJECT_SID = 10
and PRICE_BOOK_SID = 33 and CREATOR LIKE '0005546904%'
)

[mingking76]

--DELETE PRICE_INFO_TBL

select * from PRICE_INFO_TBL a where rowid not in (select min(ROWID) from PRICE_INFO_TBL b where a.PROD_SID = b.PROD_SID and a.PRICE_BOOK_SID=b.PRICE_BOOK_SID and a.CREATOR = b.CREATOR) and
a.PRICE_BOOK_SID = 33 and a.CREATOR LIKE '0005546904%'

[l_dongdong]

谢谢老兵，你回答的真快，我按照你的回复去处理，没问题。。谢谢！

mingking 的回答 我需要好好研究理解 把我的sq优化了 感谢！嘿嘿