sql 查询 [Err] ORA-00907: 缺失右括号

Question

SELECT
*
FROM
archivedconsumerecords_tmp A
WHERE
--to_char(a.archiveddate,'yyyymmdd')='20151112'
A.OID IN (
SELECT
MIN (OID)
FROM
archivedconsumerecords_tmp b
WHERE
TO_CHAR (b.tradedate, 'yyyymmdd') = '20151201'
GROUP BY
b.cardno,
b.tradedate,
b.beforetrademoney
HAVING
COUNT (*) > 1
ORDER BY
b.tradedate
)给看看这个语句为什么报缺失右括号的错误，要怎么修改，查出重复数据的全部字段

Answer 1

SELECT
*
FROM
archivedconsumerecords_tmp A
WHERE
A.OID IN (
SELECT
MIN (OID)
FROM
archivedconsumerecords_tmp b
WHERE
TO_CHAR (b.tradedate, 'yyyymmdd') = '20151201'
GROUP BY
b.cardno,
b.tradedate,
b.beforetrademoney
HAVING
COUNT (*) > 1
ORDER BY
b.tradedate
)

Answer 2

order by 去掉，已经是最小了，还排什么

Answer 3

同意楼上。
好像是说，in后面的子查询中，不能有order by。

Answer 4

group by  having