SELECT row_number() over(order by ID) as RowID,IDFROM Person
行记录编号
原文:http://www.cnblogs.com/yshic/p/3532812.html