自我回答,但是随着表的增长,我不确定这是否将是一个足够有效的解决方案:
SELECt timestamp,method,id,response FROM rpc_responses INNER JOIN(SELECt max(timestamp),method,id FROM rpc_responses GROUP BY method,id) latestUSING (timestamp,method,id);

自我回答,但是随着表的增长,我不确定这是否将是一个足够有效的解决方案:
SELECt timestamp,method,id,response FROM rpc_responses INNER JOIN(SELECt max(timestamp),method,id FROM rpc_responses GROUP BY method,id) latestUSING (timestamp,method,id);