問(wèn)題描述

寫(xiě)了好久，是在寫(xiě)不出來(lái)，請(qǐng)教大神。

其實(shí)是有點(diǎn)難度的

問(wèn)題解答

select count(ID) as counts, USER_ID,GROUP_ID,DATE_FORMAT(PTIME, ’%Y-%m’) AS timer FROM FILE_INFO GROUP BY timer,USER_ID,GROUP_ID回答2：

select user_id,date_format(ptime,’%Y%m’) month,group_id,count(*) num from file_info group by user_id,date_format(ptime,’%Y%m’),group_id;