select row_number() over( order by t.时间字段 desc) as num ,t. from 表名 t
oracle官网的描述:https://docs.oracle.com/cd/B28359_01/server.111/b28286/functions144.htm#SQLRF06100
select row_number() over( order by t.时间字段 desc) as num ,t. from 表名 t
oracle官网的描述:https://docs.oracle.com/cd/B28359_01/server.111/b28286/functions144.htm#SQLRF06100