假设您需要当前日期的前五天数据

SELECT MAX(BIL) FROM resturant
  WHERE     DATE_TIME  
 BETWEEN  
 DATE_SUB(NOW(), INTERVAL 5 DAY) AND 
 NOW();

select * 
from Restaurant 
where bill = (select MAX(bill) from Restaurant 
where date_time BETWEEN DATE_SUB(NOW(),INTERVAL 5 DAY) AND NOW() );

假设您计算的是当前日期前五天

SELECT MAX(bill) FROM restaurant_table 
   WHERE DATE_TIME  BETWEEN 
   DATE_SUB(NOW(), INTERVAL 5 DAY) 
   AND NOW();

select id,order,date_time,max(sum(bill)) as paid_bill from restaurant
   where date_time between (NOW(), INTERVAL 5 DAY) and  NOW()
   group by order;

我希望它能奏效。
where子句中的date\u time需要两个日期来过滤5天的数据
然后将所有数据分组并求和
哪一张是你的最高付账单