select *,row_number() over(order by XXX) as rownum
from view_a