php mysql分組后取分組中的第一條數(shù)據(jù)和最后一條數(shù)據(jù) 并且做統(tǒng)計這樣的MYSQL怎么寫呢

時間分組，排序字段不清，姑且按price排序吧

select 
    mtime,sum(price),sum(number),
    substring_index(group_concat(price order by price),',',1) min_price,
    substring_index(group_concat(price order by price),',',-1) max_price
from table group by mtime;

select min(price) as min_price, max(price) as max_price from (select mtime, code, sum(price) as price, sum(number) as number from table_xx group by mtime order by mtime desc) data