//最大最小价select max(price) max,min(price) min,time time from on_jiaoyi_into group by DATE_FORMAT(`time`,'%Y-%m-%d') //最初价select price,time from on_jiaoyi_into  group by DATE_FORMAT(`time`,'%Y-%m-%d')  order by time   //最末价select price,time from on_jiaoyi_into  group by DATE_FORMAT(`time`,'%Y-%m-%d')  order by time desc