mysql根据某个字段去重

在有主键的情况下

SELECT * FROM sa_request t WHERE t.logid IN ( SELECT MAX(logid) FROM sa_request GROUP BY caseid);

或者效率高些的

SELECT * FROM sa_request t WHERE EXISTS (  SELECT 1 FROM sa_request  GROUP BY caseid  HAVING MAX(logid) = t.logid);