有两张表upload1 upload2,
表upload1中的关键字段:id ,upload_time (datetime 类型)
表upload2中的关键字段:id ,upload_time (datetime 类型)问题1:
查询表upload1中上传记录数最多的一天的记录数
问题2:
查询两表中记录数最多的一天的记录数。
表upload1中的关键字段:id ,upload_time (datetime 类型)
表upload2中的关键字段:id ,upload_time (datetime 类型)问题1:
查询表upload1中上传记录数最多的一天的记录数
问题2:
查询两表中记录数最多的一天的记录数。
SELECT DATE(upload_time) AS upload_time,COUNT(*) AS cnt
FROM upload1
GROUP BY DATE(upload_time)
ORDER BY COUNT(*) DESC
LIMIT 1;
2.
SELECT DATE(upload_time) AS upload_time,COUNT(*) AS cnt
FROM (
SELECT id,upload_time FROM upload1
UNION ALL
SELECT id,upload_time FROM upload2
) AS A
GROUP BY DATE(upload_time)
ORDER BY COUNT(*) DESC
LIMIT 1;
SELECT DATE(upload_time) ,COUNT(*) AS cnt
FROM upload1
GROUP BY DATE(upload_time)
ORDER BY COUNT(*) DESC
LIMIT 1;2
SELECT DATE(upload_time) ,COUNT(*) AS cnt
FROM (
SELECT id,upload_time FROM upload1
UNION ALL
SELECT id,upload_time FROM upload2
) AS A
GROUP BY DATE(upload_time)
ORDER BY COUNT(*) DESC
LIMIT 1;