--按年统计 SELECT year(CreationTime) 年次, count(1) 销售次数, sum(Num) 销售量 FROM Orders GROUP BY year(CreationTime)
SQL 按年统计数据
最新推荐文章于 2024-07-15 02:36:36 发布
--按年统计 SELECT year(CreationTime) 年次, count(1) 销售次数, sum(Num) 销售量 FROM Orders GROUP BY year(CreationTime)