摘要： /**查询近两周销量，按照日期分组**/select tpdate.dateStr,ifnull(tpdata.count,0) as count from (SELECT @rownum:=@rownum+1 as count,date_add(DATE_FORMAT(now(),'%Y-%m-% 阅读全文