rownumber
select *,row_number() OVER(order by cat_id desc) as row_num
from pms_category
分析函数:安字段分组还会保留字段所有信息 :强大
select *,row_number() OVER(PARTITION by cat_level order by cat_id desc) row_num
from pms_category
rownumber
select *,row_number() OVER(order by cat_id desc) as row_num
from pms_category
分析函数:安字段分组还会保留字段所有信息 :强大
select *,row_number() OVER(PARTITION by cat_level order by cat_id desc) row_num
from pms_category