大神们,求sql语句 sql 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 --上边按错,不好意思select a.a,a.b,c.efrom a join (select c,count(1) as d from b group by c) c on a.a = c.c select A,B count(D)as E from (select * from 表A as a left join 表B as b on a.B=b.C) as c select a.a,a.b,c.efrom a join (select c,count(1) as d from b group by c) c on a.b = c.c--用姓名关联? SELECT A.A,A.B,COUNT(B.A)E FROM A LEFT JOIN B ON A.B=B.A GROUP BY A.A,A.B select a.a,a.b,COUNT(a.a) as e from a join b on a.b=b.cgroup by a.a select *,(select COUNT(*) from 表B where c=b)e from 表A select a.a,a.b,c.efrom a join (select c,count(1) as d from b group by c) c on a.a = c.c sqlserver2005访问权限问题--急,---上午结贴 求一sql 语句? fa_ge(鶴嘯九天)清进 请问怎么让显示数据库记录,从指定的索引开始 有难度的统计问题,高手进,谢谢。 请大家都来推荐点系统学习数据库的书 关于两个相同金额自动匹配的问题 sql 时间段的设置 vb 实现sql数据转移,具体问题如下,实在没有办法?????????????? ADO调用存储过程,如何得到返回值? SQL 表中求同一列不同行的差值 数据库表名称如何写活
--上边按错,不好意思
select a.a,a.b,c.e
from a join (select c,count(1) as d from b group by c) c on a.a = c.c
select A,B count(D)as E from (
select * from 表A as a left join 表B as b on a.B=b.C
) as c
select a.a,a.b,c.e
from a join (select c,count(1) as d from b group by c) c on a.b = c.c
--用姓名关联?
on a.b=b.c
group by a.a
from a join (select c,count(1) as d from b group by c) c on a.a = c.c