感谢@Jim Garrison。解决方案是使用ROWNUM属性:
我只想得到这个查询的第一个结果,但每当我写下LIMIT时。Oracle SQL Developer向我抛出此错误
*ORA-00933:SQL命令未正确结束00933.00000-"SQL命令未正确结束"*原因:
行动:第6行第7列错误
这是代码:
SELECT IDBAR FROM ( SELECT PARRANDEROS.FRECUENTAN.ID_BAR as IDBAR,
COUNT(PARRANDEROS.FRECUENTAN.ID_BAR) c
FROM PARRANDEROS.FRECUENTAN
GROUP BY PARRANDEROS.FRECUENTAN.ID_BAR
ORDER BY c DESC
)
LIMIT 1;
我也尝试过这种方法:
SELECT IDBAR FROM ( SELECT PARRANDEROS.FRECUENTAN.ID_BAR as IDBAR,
COUNT(PARRANDEROS.FRECUENTAN.ID_BAR) c
FROM PARRANDEROS.FRECUENTAN
GROUP BY PARRANDEROS.FRECUENTAN.ID_BAR
ORDER BY c DESC
LIMIT 1
);
非常感谢。
SELECT IDBAR FROM ( SELECT PARRANDEROS.FRECUENTAN.ID_BAR as IDBAR,
COUNT(PARRANDEROS.FRECUENTAN.ID_BAR) c
FROM PARRANDEROS.FRECUENTAN
GROUP BY PARRANDEROS.FRECUENTAN.ID_BAR
ORDER BY c DESC
)
WHERE ROWNUM <= 1;