视图增加自增id

select *,row_number() over(order by XXX) as rownum
from view_a
posted @ 2012-08-01 17:22  y0umer  阅读(447)  评论(0)    收藏  举报