SELECT * FROM rsl a, (SELECT CODE, max(time_key) time_key FROM rsl GROUP BY CODE ) b WHERE a. CODE = b. CODE AND a.time_key = b.time_key AND a. CODE IN (‘HK.00700‘, ‘HK.03888‘);
table :rsl
然后查询出根据每一种的code 中最新的一组数据
原文：http://www.cnblogs.com/honey01/p/7358797.html