select row_number() over (order by columnName) as No,* from tableName
抽取的结果
NO C1 C2 C3
1 1 00 青銅
2 3 00 単位
3 0 00 名称
4 4 01 CAC92
5 12 01 CAC92
6 1 01 銅
7 2 01 CAC92