两种方法:
1.加limit
SELECT id,date,status, operation, ifnull( account, ‘’ ) AS account, ifnull( remark, ‘’ ) AS remark FROM ( SELECT * FROM so_store_log ORDER BY date desc limit 100000000 ) SSL2 GROUP BY id, operation ORDER BY update_date DESC
2.不好理解 (多条)
SELECT * FROM ( SELECT * FROM so_store_log ORDER BY update_date DESC ) SSL1 where ssl1.update_date in ( select max(ssl2.update_date ) from (SELECT * FROM so_store_log ORDER BY update_date DESC) ssl2 GROUP BY id, operation
ORDER BY update_date DESC )