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

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

posted @ 2018-09-10 14:54  keyboardone  阅读(238)  评论(0)  编辑  收藏  举报