如标题所示,我需要获取前5天,6-10天的数据。----
2019-11-042019-11-102019-11-30Select count(date) Where cast(cdate as date) between cast(cdate as date)and dateadd(day,5,cdate) Group by cdate
Expected r
我有一个mysql表,如下所示:当访问者访问网站时,它将访问者id和页面id存储为一行。SELECT COUNT(visid),visid FROM vislog GROUP BY visid ORDER BY COUNT(visid) DESC
但我不知道下一步该怎么计算可以像MySQL查询一样做吗?