m0_37891495的博客

按年汇总，统计：select sum(mymoney) as totalmoney, count(*) as sheets from mytable group by date_format(col, '%Y');按月汇总，统计：select sum(mymoney) as totalmoney, count(*) as sheets from mytable group by da...

SELECT `时间`,count(`时间`) FROM (SELECT DISTINCT `订单编号`,`时间` from `零售` where `订单编号` not like '%C%') GROUP BY `时间`;运行语句时，提示错误：[Err] 1248 - Every derived table must have its own alias一般出现在嵌套语句中，为派生...