任意维度过虑,取结果集中最新一条XXX ROW_NUMBER() OVER()

ROW_NUMBER() OVER(PARTITION BY t.info_type ORDER BY t.info_date DESC) as rn,

原文地址:https://www.cnblogs.com/keyboardone/p/9619665.html