select saleid, sum(money*0.01) as [money] from ChargeConsume group by saleid
select operateCard,money,saleid, sum(money*0.01) as [money] from ChargeConsume group by saleid版主,按的写法,我改成这样,提示 “因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中” 不通过呀
既然对money聚合,就不要在查询列了。operateCard 也不要在查询列了。 应该这样select saleid, sum(money*0.01) as [money] from ChargeConsume group by saleid select operateCard,money,saleid, sum(money*0.01) as [money] from ChargeConsume group by saleid版主,按的写法,我改成这样,提示 “因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中” 不通过呀
select operateCard,money,saleid, sum(money*0.01) as [money] from ChargeConsume group by saleid版主,按的写法,我改成这样,提示 “因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中” 不通过呀 我知道语法上要按你说的这样,可是我要的结果是要有operateCard的呀
select operateCard,money,saleid, sum(money*0.01) as [money] from ChargeConsume group by saleid版主,按的写法,我改成这样,提示 “因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中” 不通过呀 我知道语法上要按你说的这样,可是我要的结果是要有operateCard的呀 如果money合并了,那么对应的operateCard都2条,你要显示哪个呢?
select saleid,min(operateCard) as operateCard, sum(money*0.01) as [money] from ChargeConsume group by saleid
select operateCard,money,saleid, sum(money*0.01) as [money] from ChargeConsume group by saleid版主,按的写法,我改成这样,提示 “因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中”
不通过呀
应该这样select saleid, sum(money*0.01) as [money] from ChargeConsume group by saleid
select operateCard,money,saleid, sum(money*0.01) as [money] from ChargeConsume group by saleid版主,按的写法,我改成这样,提示 “因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中”
不通过呀
select operateCard,money,saleid, sum(money*0.01) as [money] from ChargeConsume group by saleid版主,按的写法,我改成这样,提示 “因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中”
不通过呀 我知道语法上要按你说的这样,可是我要的结果是要有operateCard的呀
select operateCard,money,saleid, sum(money*0.01) as [money] from ChargeConsume group by saleid版主,按的写法,我改成这样,提示 “因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中”
不通过呀 我知道语法上要按你说的这样,可是我要的结果是要有operateCard的呀
如果money合并了,那么对应的operateCard都2条,你要显示哪个呢?
这个在SQL中很难实现。
SQL顶多就能实现以下格式:
00026 1000 100
00026 1000 (空格)
00026 1000 (空格)