不好意思,写错了SELECT AID,targetMapID,(SELECT COUNT(AID) FROM useraction WHERE AID = tem.AID) AS hits, time FROM useraction tem WHERE (time =(SELECT MAX(time) FROM useraction WHERE AID = tem.AID)) order by hits desc limit 10
调试欢乐多
难道是不支持复合查询??郁闷!
targetMapID,
(SELECT COUNT(AID) FROM useraction WHERE AID = tem.AID) AS hits,
time
FROM useraction tem
WHERE
(time =(SELECT MAX(time) FROM useraction WHERE AID = tem.AID))
ORDER BY hits DESC LIMIT 10建表语句与数据插入语句和结果能帖出来吗??
这些是标准的函数,主要原因应该是不支持嵌套的select语句
如果真的想转过去,只能重写这些sql了
在mysql手册中有相关的介绍。