现在:
date id '07/07' 1 '07/07' 2 '07/07' 3 '07/05' 4 '07/05' 5
我想要的是:
date id '07/07' 3 '07/05' 5
DELETE FROM table WHERE id NOT IN (SELECT MAX(id) FROM table GROUP BY date);