我正在尝试了解如何在表中显示一行中所有项目的总值(项目*数量)。下面的代码在一行中显示了每一项的总和,而不是所有项的总价值。如何做到这一点?SELECT CONVERT(Decimal(8,0),ROUND((quantity*price),2)) AS Total编辑:由于错误,我包含了ITEMNAME,这不应该是结果的一部分该表的设计如下:
我在python中执行了以下mysql查询:"SELECT DISTINCT(AddressA) AS Source, SUM(Packets) As Total_Packets, SUM(Bytes) AS Total_Bytes, SUM(Duration) As Total_Duration FROM control_convo GROUP BY Source;"**当我在每个包中打印Bytes时