query the top N users with the largest number of courses, and the number of courses should also be queried
the corresponding sql is as follows:
<select id="getUserWithMostFans" resultMap="">
SELECT t.userId,t.selectNum
...
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5 MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1eac063-47e79.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") MySQL Errno : 1021 Message : Disk full (/tmp/#sql-temptable-64f5-1eac063-47e79.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") Need Help?
