select * from (select count(*) cou, t.info_id from t_visit_logs t group by t.info_id order by cou desc) ff where rownum <= 10; 例句十个嵌套查询,只用一个sql是不是可以完成,怎么写。谢谢
你是想得到cou值最高的10个info_id吗? 如果这样的话,你这条语句应该改改一下吧select rownum,cou,id from (select count(*) cou, t.info_id as id from t_visit_logs t group by t.info_id order by cou desc) ff where rownum <= 10;试试吧,我不确定能不能用
套一层还少了,要两层才行的 SELECT cou, info_id FROM (SELECT cou, info_id FROM (SELECT COUNT (*) cou, t.info_id FROM t_visit_logs t GROUP BY t.info_id) ORDER BY cou DESC) WHERE ROWNUM <= 10
如果这样的话,你这条语句应该改改一下吧select rownum,cou,id from (select count(*) cou, t.info_id as id from t_visit_logs t group by t.info_id order by cou desc) ff where rownum <= 10;试试吧,我不确定能不能用
SELECT cou, info_id
FROM (SELECT cou, info_id
FROM (SELECT COUNT (*) cou, t.info_id
FROM t_visit_logs t
GROUP BY t.info_id)
ORDER BY cou DESC)
WHERE ROWNUM <= 10