mysql - Group by -having 从 mysql 到 oracle 的语句

Question

我有这个语句，它在 MySQL 中运行良好

SELECT r
  FROM (  SELECT MAX(recno) AS r,
                 f1,
                 f2,
                 f3,
                 f4,
                 f5,
                 f6,
                 f7,
                 f8,
                 COUNT(*) AS count2
            FROM mytable
        GROUP BY f1,
                 f2,
                 f3,
                 f4,
                 f5,
                 f6,
                 f7,
                 f8
          HAVING (count2 > 1)) tr

但在 Oracle 中效果不佳

ORA-00904: invalid identifier "count2"

如何让它在 Oracle 中运行？

Answer 1

就用

HAVING COUNT(*) > 1

因为你不能使用别名。