从sqlServer2000查询语句转到mySQL出错，请问如何改！ 现场散分！！！

[tinyhuhu]

SELECT AID,targetMapID,(SELECT COUNT(AID) FROM useraction WHERE AID = tem.AID) AS num, time FROM useraction tem WHERE (time =(SELECT MAX(time) FROM useraction WHERE AID = tem.AID)) order by hits desc limit 10


如何转到mysql的语法？？？ 因为sqlServer的函数COUNT MAX等函数都不能在mysql中用，而mysql中的语法是什么呢

急！！！

[tinyhuhu]

不好意思，写错了

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

[txlicenhe]

建议转版

[tinyhuhu]

我在那个版也问了啊，没人回！

你会吗，马可兄？

[tinyhuhu]

ding

[zjcxc]

不懂mysql

[tinyhuhu]

一句在sqlServer中好端端的查询，转到mysql中就不行了，而mySql中有count,max等函数
难道是不支持复合查询？？

郁闷！