SELECT date_format( a.date, '%c.%d' ) times, b.count AS totals FROM (SELECT curdate( ) AS date UNION ALLSELECT date_sub( curdate( ), INTERVAL 1 DAY ) AS date UNION ALLSELECT date_sub( curdate( ), INTERVAL 2 DAY ) AS date UNION ALLSELECT date_su
摘要由CSDN通过智能技术生成
sql语句统计最近七天的数据
SELECT
date_format( a.date,'%c.%d') times,
b.count AS totals
FROM
(
SELECT
curdate() AS date UNION ALL
SELECT
date_sub( curdate(), INTERVAL 1 DAY ) AS date UNION ALL
SELECT
date_sub( curdate(), INTERVAL 2 DAY ) AS date UNION ALL
SELECT
date_sub( curdate(
SELECT date_format( a.date, '%c.%d' ) times, b.count AS totals FROM (SELECT curdate( ) AS date UNION ALLSELECT date_sub( curdate( ), INTERVAL 1 DAY ) AS date UNION ALLSELECT date_sub( curdate( ), INTERVAL 2 DAY ) AS date UNION ALLSELECT date_su