SQL:如何选择每天最多一条记录？

SELECT t1.*
FROM table_name t1
INNER JOIN (
    SELECT MAX(date) AS max_date, DATE(date) AS date_only
    FROM table_name
    GROUP BY DATE(date)
) t2 ON t1.date = t2.max_date

SELECT *
FROM (
    SELECT *,
        ROW_NUMBER() OVER (PARTITION BY DATE(date) ORDER BY date DESC) AS row_num
    FROM table_name
) t
WHERE t.row_num = 1

SELECT *
FROM table_name
WHERE date IN (
    SELECT MAX(date)
    FROM table_name
    GROUP BY DATE(date)
)