好资源导航 » 文章资讯 » 选择与MySQL的分组总结？

选择与MySQL的分组总结？

2024-05-18 20:54:03 449

总而言之，请使用聚合函数SUM()。这样，使用MySQLGROUPBY进行分组。让我们首先创建一个表-

create table DemoTable
   -> (
   -> ProductName varchar(20),
   -> ProductQuantity int,
   -> ProductPrice int
   -> );

使用插入命令在表中插入一些记录-

insert into DemoTable values('Product-1',2,50);
insert into DemoTable values('Product-2',3,80);
insert into DemoTable values('Product-2',4,100);
insert into DemoTable values('Product-1',4,150);

使用select语句显示表中的所有记录-

select *from DemoTable;

+-------------+-----------------+--------------+
| ProductName | ProductQuantity | ProductPrice |
+-------------+-----------------+--------------+
| Product-1   |               2 |           50 |
| Product-2   |               3 |           80 |
| Product-2   |               4 |          100 |
| Product-1   |               4 |          150 |
+-------------+-----------------+--------------+
4 rows in set (0.00 sec)

以下是在MySQL分组选择查询-

select *,sum(ProductQuantity*ProductPrice) as Total from DemoTable
   -> group by ProductName;

+-------------+-----------------+--------------+-------+
| ProductName | ProductQuantity | ProductPrice | Total |
+-------------+-----------------+--------------+-------+
| Product-1   |               2 |           50 |   700 |
| Product-2   |               3 |           80 |   640 |
+-------------+-----------------+--------------+-------+
2 rows in set (0.00 sec)

返回顶部
3162201930
czq8825@qq.com

选择与MySQL的分组总结？

热门推荐

随机推荐