求求高手帮忙啊。。select * from DayCost查询结果如图分组的时候,我想知道1组里面有几个数据 价钱一共是多少钱 显示 时间
那个时间能不能按月查询呢,... 我想按月查询出来了。谢谢你了。分享一下,select substring(date,0,8) as date , count(*) as num , sum(price) as Price from DayCost group by substring(date,0,8) order by date