小弟请教问题 SELECT A.HYKH,SUM(A.XFJE) AS HZJE FROM BC_HYKXFLSK A LEFT JOIN BC_HYKK B ON A.HYKH = B.HYKH GROUP BY A.HYKH HAVING SUM(A.XFJE) > 1000 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT A.HYKH,SUM(A.XFJE) AS HZJE FROM BC_HYKXFLSK A LEFT JOIN BC_HYKK B ON A.HYKH = B.HYKH GROUP BY A.HYKH having sum(A.XFJE)>100 SELECT A.HYKH,SUM(A.XFJE) AS HZJE FROM BC_HYKXFLSK A LEFT JOIN BC_HYKK B ON A.HYKH = B.HYKH GROUP BY A.HYKH having sum(A.XFJE)>100 SELECT A.HYKH,SUM(A.XFJE) AS HZJE FROM BC_HYKXFLSK A LEFT JOIN BC_HYKK B ON A.HYKH = B.HYKH having SUM(A.XFJE) > 1000 GROUP BY A.HYKH SELECT A.HYKH,SUM(A.XFJE) AS HZJE FROM BC_HYKXFLSK A LEFT JOIN BC_HYKK B ON A.HYKH = B.HYKH GROUP BY A.HYKH having SUM(A.XFJE) > 1000 sql按条件分组 解救~~~~~ 访问数据库出现“SQL Server 不存在或访问被拒绝”!!! 请问如何得到最近6次的单价变动情况 请问如何不通过sql手动打开1433端口? 问一下:什么是数据库的三级模型结构?(在线等) 有关sql 的两个问题 怎么计算记录之间的相似度 这样的一个查询的sql语句怎么写? 抗议:怎么回事,我的可用分变成了0!!! 关于汇总报表问题,100分!!!(大力请进) Log restore 所花费的时间长短与什么有关 数据迁移过程中,关于 text,ntext以及image的字段的数据迁移问题?
SELECT A.HYKH,SUM(A.XFJE) AS HZJE FROM BC_HYKXFLSK A
LEFT JOIN BC_HYKK B
ON A.HYKH = B.HYKH
GROUP BY A.HYKH
having sum(A.XFJE)>100
SELECT A.HYKH,SUM(A.XFJE) AS HZJE FROM BC_HYKXFLSK A
LEFT JOIN BC_HYKK B
ON A.HYKH = B.HYKH
GROUP BY A.HYKH
having sum(A.XFJE)>100
SELECT A.HYKH,SUM(A.XFJE) AS HZJE FROM BC_HYKXFLSK A
LEFT JOIN BC_HYKK B
ON A.HYKH = B.HYKH
having SUM(A.XFJE) > 1000
GROUP BY A.HYKH
SELECT A.HYKH,SUM(A.XFJE) AS HZJE FROM BC_HYKXFLSK A
LEFT JOIN BC_HYKK B
ON A.HYKH = B.HYKH
GROUP BY A.HYKH
having SUM(A.XFJE) > 1000