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本文共 230 字，大约阅读时间需要 1 分钟。
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转载于:https://www.cnblogs.com/zhufangyuan09/p/11321875.html