摘要： --查询近7天数据记录行数，没有返回0 select a.click_date,ISNULL(b.count,0) as countfrom ( SELECT convert(varchar(10),getdate()-7,120) as click_date union all SELECT co 阅读全文