摘要：
SQL语句统计每天、每月、每年的数据1、每年selectyear(ordertime)年，sum(Total)销售合计from订单表groupbyyear(ordertime)2、每月selectyear(ordertime)年，month(ordertime)月,sum(Total)销售合计from订单表groupbyyear(ordertime)，month(ordertime3、每日selectyear(ordertime)年，month(ordertime)月,day(ordertime)日，sum(Total)销售合计from订单表groupbyyear(ordertime)，mon 阅读全文