select *,row_number() over(order by XXX) as rownum from view_a 转载于:https://www.cnblogs.com/y0umer/archive/2012/08/01/3839517.html