select t.a,t.b from t where t.c in (1, 2, 3, 4, 5) order by created_at desc; 怎么让每个 c 只返回一个结果?即最新created_at desc那个. 如果直接这样: select t.a,t.b from t where t.c in (1, 2, 3, 4, 5) order by created_at desc limit 1; 就全部一个结果.
因为 select t.a,t.b from t where t.c = 1/2/3/4/5 每个都会返回多个结果