mysql查询年龄大于20岁的前5名的平均成绩 mysql 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select avg(score )from(select top 5 *from twhere age>20order by score desc) select avg(score )from(select top 5 *from twhere age>20order by score desc) a #MySQL select avg(score) from table where age>20 order by score desc limit 5; select avg(a.score) from (select score from user where age > 21 order by score desc limit 0,2) as a;这样就可以了,自己破了。 实在没看懂 > 21 和 limit 0,2啊 mysqlselect avg(score) from (select * from table where age>20 order by score desc limit 5) as a; 怎么错了? 求一算法 ~ Order by 问题??? Unicode 和非Unicode 之间有什么区别 我一直不是很清楚 请高手说下 mssql数据库压缩对符号的支持问题,急,再线等 订票系统 请教 双表查询 把语句里的两个 NOT EXISTS 都改为 EXISTS 是一样么? A库中的某些表的某些字段相关数据要即时的复制到B库对应的表中,咋办? 我想同时操作两张表,我该怎么办? 重复数据保留,并某列求和 求高手帮忙写一个触发器,小妹跪求啊
from(
select top 5 *
from t
where age>20
order by score desc)
from(
select top 5 *
from t
where age>20
order by score desc) a
#MySQL
select avg(score) from table
where age>20
order by score desc
limit 5;
) as a;这样就可以了,自己破了。
mysql
select avg(score) from (select * from table where age>20 order by score desc limit 5) as a;