select aaa.a,sum(bbb.x) as xx,sum(ccc.y) as yy
from aaa
join bbb on aaa.a = bbb.a
join ccc aaa.a=ccc.a
group by aaa.a
order by bbb.x
from aaa
join bbb on aaa.a = bbb.a
join ccc aaa.a=ccc.a
group by aaa.a
order by bbb.x
解决方案 »
- 请看这个错误怎么解决?
- 麻烦各位看看这段简单的把10位字符串转化为datetime型的语句!有错误提示!
- 一巨难的问题,请大家帮忙
- 请问下面的语句是否能优化,提高查询效率?
- !!!SQL6.5备份出来的数据是.BAT的,要恢复到SQL2000中!!!
- 求救! SQL高手进~~~~~~~
- 好困惑啊,谁知道?
- 大家帮忙看一下这个问题,sql server
- 急急急!!!大侠请进!!
- 机器启动后第一次sql2008r2用OPENROWSET('Microsoft.ACE.OLEDB.12.0' ... 读取ACCESS总是会断开服务
- 如何将vb中的string转为sql serve中的datetime啊
- 求一个存储过程
from aaa
join bbb on aaa.a = bbb.a
join ccc aaa.a=ccc.a
group by aaa.a
order by bbb.x是不是数据量过大﹐导致超时
( select aaa.a,sum(ccc.y) as yy from aaa,ccc where aaa.a=ccc.a group by aaa.a)b
where a.a=b.a