select 要查询的值,row_number() over(order by 表中某一个值) as 起一个列名 from 要查询的表名例:
select distinct user_guid,row_number() over(order by user_guid) as rows from ods.t_hitch_driver_info