如何使用php从sql回显一整天的最高值一厘米

Question

How to echo highest value of a centimeter for the whole day from SQL using PHP

this is my database :

-------------------------------
id | date       | centimeter  
------------------------------
1  | 2014-01-31 | 160    
2  | 2014-02-28 | 800   
3  | 2017-03-31 | 23   
4  | 2016-04-30 | 130 
5  | 2016-04-30 | 600 
6  | 2017-03-31 | 700  
7  | 2014-03-28 | 200  

i want to echo it in PHP this way :

2017-03-31  700 
2016-04-30  600 
2014-03-28  200 

*i want to echo only 1 highest centimeter by day

Answer 1

select date, max(centimeter)
from your_table
group by date