获取表中每个编号最新一条数据的集合

SQL例句：

SELECT *
  FROM (SELECT row_number() over(PARTITION BY 编号 ORDER BY 日期 DESC) as indexnum,* FROM 数据表) as t
 WHERE t.indexnum = 1;