--按年统计 SELECT year(CreationTime) 年次, count(1) 销售次数, sum(Num) 销售量 FROM Orders GROUP BY year(CreationTime)
SQL 按年统计数据
最新推荐文章于 2023-10-26 09:24:05 发布
--按年统计 SELECT year(CreationTime) 年次, count(1) 销售次数, sum(Num) 销售量 FROM Orders GROUP BY year(CreationTime)