34,871
社区成员
发帖
与我相关
我的任务
分享比较查询速度----
select a,b=(select sum(c) from t1 where t.a=t1.a)
from t
和
select a,d.h
from t
inner join
(select a,sum(c) as h from t1) D on t.a=t1.a
from t
和
select a,d.h
from t
inner join
(select a,sum(c) as h from t1) D on t.a=t1.a
...全文
请发表友善的回复…
发表回复
shuiniu 2003-12-22
- 打赏
- 举报
ctrl+L
victorycyz 2003-12-22
- 打赏
- 举报
我认为这样更好：
select a,sum(c) as h
from t
inner join t1 on t.a=t1.a
group by t.a
select a,sum(c) as h
from t
inner join t1 on t.a=t1.a
group by t.a
azsoft 2003-12-22
- 打赏
- 举报
如何比较？
cgsun 2003-12-22
- 打赏
- 举报
ctrl+L
