Select panelName,sum(replynum)+count(*) from articles natural join panels group by panelName order by (sum(replynum)+count(*)) desc having rownum=1; having rownum=1的位置好像不对啊,就是要取最大值,该怎么改?
SELECT * FROM (SELECT panelName, SUM(replynum) + COUNT(*) FROM articles NATURAL JOIN panels GROUP BY panelName ORDER BY (SUM(replynum) + COUNT(*)) DESC) WHERE rownum < 2;
FROM (SELECT panelName, SUM(replynum) + COUNT(*)
FROM articles NATURAL
JOIN panels
GROUP BY panelName
ORDER BY (SUM(replynum) + COUNT(*)) DESC)
WHERE rownum < 2;