I have the following statement:
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);
It provides the following result set:
| day | average |
|---|---|
| date | value |
| date | value |
| date | value |
| date | value |
| date | value |
| date | value |
| date | value |
How to display only the lowest value in the result set instead of all 7 values?
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
You just need to use order by and 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