工作 巧遇 sql 查询 一组数据中 最新的一条

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');SELECT * FROM rsl a, (SELECT CODE, max(time_key