ROW_NUMBER() OVER(PARTITION BY COLUMN1 ORDER BY COLUMN2)
根据COLUMN1分组,组内根据COLUMN2排序,而此函数计算的值就表示每组内部排序后的顺序编号.
e.g.select tpi.id,
tpi.project_type,
row_number() over(partitionby tpi.project_type order by to_number(tpi.lc_project_id))rank
from t_project_info tpi