ROW_NUMBER() OVER(PARTITION BY COLUMN ORDER BY COLUMN) 转载于:https://www.cnblogs.com/fighting-from-now/p/3611495.html