qq_42910382的博客

mysql根据日分组查询 SELECT DATE_FORMAT( f.SCAN_DATE_TS, '%Y-%m-%d' ) as senName, count( 1 ) as allCount FROM sp_dscvr_files f WHERE 1 = 1 GROUP BY senName mysql 根据周分组查询 SELECT DATE_FORMAT(f.SCAN_DATE_TS,'%Y-%U') as senName,// 返回某一年的第几