mysql设置查询结果最大值_查找MySQL查询结果字段的最大值

将它连接到仅有最大计数的第二个查询。每天最内部查询(对于给定用户)每天计数的一组行数。从那以后，下一个外部执行从该集合中选择MAX()来查找并获得一个代表最高日数的记录...因为它总是返回一行，并且加入到原始的numRequest表中它将是一个笛卡尔，但没有问题，因为它只有一条记录，无论如何你想要每个返回行的值。

select

id_re_usr,

year(time) as AYear,

DAYOFYEAR(time) as ADay,

DATE_FORMAT(time, "%m-%d-%y") as date,

count(*) as TotalPerDay,

HighestCount.Max1 as HighestOneDayCount

from

numrequest,

( select max( CountsByDate.DayCount ) Max1

from ( select count(*) as DayCount

from numrequests nr

where nr.id_re_usr = "u1"

group by date( nr.time )) CountsByDate

) HighestCount

where

id_re_usr = "u1"

group by

id_re_usr,

AYear,

ADay

order by

AYear,

ADay