原语句
select *,row_number() over( order by 'updtime' desc) clm1 from table_name
修改后的语句
select a.*,row_number() over( order by 'updtime' desc) clm1 from table_name a
原语句
select *,row_number() over( order by 'updtime' desc) clm1 from table_name
修改后的语句
select a.*,row_number() over( order by 'updtime' desc) clm1 from table_name a