请问这个sql能不能优化 select top 9 t.member,t.h from (select sum(hits) as h, member from pp_photo group by member) as t order by t.h desc就是查询点击量最高的会员这样写可以正确查询但不知有没有得优化 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 declare @t table(hits int,member varchar(20))select top 9 sum(hits) as h, member from @tgroup by memberorder by h select top 9 sum(hits) as h, member from @tgroup by memberorder by h desc select top 9 member,sum(hits) as h from pp_photo group by member order by h desc 只是能做语句简化,优化就谈不上了, 外部查询对子查询并没有什么影响,所以二者执行的过程是一样的。就像:select 8* from select * from tb和select * from (select * from tb) x一样。 请帮忙 询问一个分类提取数据的sql 谁能单独教我下,很简单的触发器怎么写 高分之下必有能人 能否让计算机每天零点自动备份数据库?而且每天自动备份的文件名要不同! 救命!!在线等。数据库误删除怎么恢复? 高难度!一句SQL如何能实现这样的功能? 哪位达人给一个通用更新主明细表的方法或思路 如何优化处理?? 新人求帮助 datetime类型的搜索 关于更新一列的数据
from @t
group by member
order by h
from @t
group by member
order by h desc
select top 9 member,sum(hits) as h
from pp_photo
group by member
order by h desc
select 8* from select * from tb
和
select * from (select * from tb) x
一样。