我这里不方便创建很多测试数据。
就简单模拟模拟吧
CREATE TABLE test100 (
cid INT,
num_iid INT,
dateline DATE
);
INSERT INTO test100
SELECT 1, 1, '2013-05-01' UNION ALL
SELECT 1, 2, '2013-05-02' UNION ALL
SELECT 2, 3, '2013-05-03' UNION ALL
SELECT 2, 4, '2013-05-04' UNION ALL
SELECT 3, 5, '2013-05-05' UNION ALL
SELECT 3, 6, '2013-05-06' UNION ALL
SELECT 4, 7, '2013-05-07' UNION ALL
SELECT 4, 8, '2013-05-08' UNION ALL
SELECT 5, 9, '2013-05-09' UNION ALL
SELECT 5, 10, '2013-05-10' UNION ALL
SELECT 6, 11, '2013-05-11' UNION ALL
SELECT 6, 12, '2013-05-12';
SELECT
*
FROM
test100 main
WHERE
NOT EXISTS( SELECT 1 FROM test100 sub WHERE main.cid = sub.cid AND main.dateline < sub.dateline)
ORDER BY
dateline DESC
LIMIT 5;