SELECT top 1 count(book_id) as m FROM `browse_history` group by `user_ID` order by count(book_id) desc
select max(m) from (SELECT user_id,count(book_id) as m FROM `browse_history` group by `user_ID`) tmp
这句不行,#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 count(book_id) as m FROM `browse_history` group by `user_ID` order by count(bo' at line 1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货