我有以下聲明：
select DATE(recieved_on) as Day, round (count(*) / 24) AS 'average'
from message
where facility in ('FACID')
AND received on BETWEEN '2022-05-29 00:00:00' AND '2022-06-04 23:59:59'
GROUP BY DATE(received on);
它提供了以下結(jié)果集：
| 日 | 平均 |
|---|---|
| 日期 | 值 |
| 日期 | 值 |
| 日期 | 值 |
| 日期 | 值 |
| 日期 | 值 |
| 日期 | 值 |
| 日期 | 值 |
如何僅顯示結(jié)果集中的最低值而不是全部 7 個(gè)值？
1
0
0
您只需使用 order by 和 limit 即可：
select DATE(recieved_on) as Day, round (count(*) / 24) AS 'average'
from message
where facility in ('FACID') AND received on BETWEEN '2022-05-29 00:00:00' AND '2022-06-04 23:59:59'
GROUP BY DATE(received on)
order by average
limit 1
