第2个应该是: SELECT sum(price) AS 所有商品价格的和, sum(price) / count(num) AS 所有商品平均价格 FROM goods |
已经有大神解答出来了,分享给大家!! ----------------------------------------------------------------------------- 1. SELECT id, gname, price AS 原价, price * 0.5 AS 五折价格, num, description FROM goods -------------------------------------------------------------------- 2. SELECT sum(price) AS 所有商品价格的和, sum(price) / sum(num) AS 所有商品平均价格 FROM goods |
|申请友链|小黑屋|Archiver|手机版|MySQL社区
( 京ICP备07012489号 )
联系人:周生; 联系电话:13911732319
GMT+8, 2024-5-8 05:32 , Processed in 0.100890 second(s), 29 queries , Gzip On.
Powered by Discuz! X3.2
© 2001-2013 Comsenz Inc.