国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

masyarakat

Belajar

Perpustakaan Alatan

Alat AI

Masa lapang

Melayu

Bagaimana untuk memaparkan hanya nilai terendah daripada set hasil (MYSQL)

P粉338969567 2024-04-06 21:44:19

1348

Saya mempunyai kenyataan berikut:

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);

Ia menyediakan set hasil berikut:

Hari	Sederhana
Tarikh	Nilai
Tarikh	Nilai
Tarikh	Nilai
Tarikh	Nilai
Tarikh	Nilai
Tarikh	Nilai
Tarikh	Nilai

Bagaimana untuk memaparkan hanya nilai terendah dalam set hasil dan bukannya kesemua 7 nilai?

P粉338969567

membalas semua(1)

P粉7908197272024-04-07 16:45:30 Tingkat 1

Anda hanya gunakan pesanan mengikut dan hadkan:

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