row_number()over(order by id) SQL顺序排列 select *,row_number()over(order by id) as number_id from [dbo].tb_pccw20140213