插入序号
row_number() OVER(ORDER BY MesOrd.sNumber ASC) AS [序号],
原文:http://www.cnblogs.com/Michael-D/p/4335689.html