摘要：SELECT * FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY 某字段1 ORDER BY 某字段1,某时间字段2 DESC ) rn FROM table) t WHERE rn = 1 例如 ： EduCompetitionofStudents 阅读全文