Oracle11g可选先取？

Question

这段代码在oracle11g sql中运行良好，但是当我将它放到服务器im中时，如果没有正确结束SQL命令，就会怀疑它是否因为其不同的甲骨文版本而处于oracle11g中。

SELECT g.GID, g.Name, COUNT(*) as cnt
FROM VisitN v JOIN
     GuestN g
     ON v.GID = g.GID
GROUP BY g.GID, g.Name
ORDER BY cnt DESC
FETCH FIRST 1 ROWS ONLY;

谢谢

Answer 1

您可以使用ROWNUM。例如：

select *
from (
  SELECT g.GID, g.Name, COUNT(*) as cnt
  FROM VisitN v JOIN
     GuestN g
     ON v.GID = g.GID
  GROUP BY g.GID, g.Name
  order by cnt desc
) x
where rownum = 1

请参见在db<>fiddle上运行示例。