给个SQL语句吧,在线等待 select * from table where CUSTMER in (select CUSTMER from table group by CUSTMER where sum(PRICE)>0) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT * FROM CUSTMER aWHERE a.NAME IN (SELECT NAME FROM CUSTMER GROUP BY NAME HAVING SUM(PRICE)<>0) select * from tablename awhere a.customer in (select customer from tablenamegroup by customerhaving sum(price) <> 0) select * from table as A where (select sum(PRICE) from yourtable where CUSTMER = A.CUSTMER) >0 SELECT * FROM CUSTMER aWHERE a.NAME IN (SELECT NAME FROM CUSTMER GROUP BY NAME HAVING SUM(PRICE)<>0) mssql按照datetime栏位分组 关于SQL生成XML的问题? 请问 top 后能否跟参数? 关于跨月计算的问题 sql 邮件----急急急 SQL语句实现横排? 怎样连接SQL server服务器??(在线) 数值型数据转化的问题 如何分别SQL Server2000 里表的主键呀 ??? DataEnviroment中调用存储过程怎么得到存储过程的返回值 如果在查询分析器中利用sql语句为角色赋操作权限?(最好有个例子看看) 已知字段名和对应的值,怎样获得行号?
WHERE a.NAME IN (SELECT NAME FROM CUSTMER
GROUP BY NAME
HAVING SUM(PRICE)<>0)
where a.customer in (
select customer from tablename
group by customer
having sum(price) <> 0
)
(select sum(PRICE) from yourtable where CUSTMER = A.CUSTMER) >0
WHERE a.NAME IN (SELECT NAME FROM CUSTMER GROUP BY NAME HAVING SUM(PRICE)<>0)