how can i find out the row which i want in msyql , thanks a lot : I have mysql table like follow:

 

       id  primary key, 
       list_id int,  
       item_id  int, 
       created  timestamp.


now , I want to find out the row's list_id  which after I group by item_id, and fetch the row with the highest created. . . . . can someone tell me what sql query can do this, thanks a lot!




