sql代码:按指定顺序产生对应序号
select row_number() over (order by instr('A,C,B,E,D,F',区域)) ROWINDEX,
区域,
S1,
S2,
S3,
S4,
S5,
S6,
S7
from TABLE
where 1=1
order by instr('A,C,B,E,D,F',区域)
产生对应序号
ROWINDEX | 区域 | S1 | S2 |
1 | A | ||
2 | C | ||
3 | B | ||
4 | E | ||
5 | D | ||
6 | F |
sql代码:按指定顺序产生对应序号
select row_number() over (order by instr('A,C,B,E,D,F',区域)) ROWINDEX,
区域,
S1,
S2,
S3,
S4,
S5,
S6,
S7
from TABLE
where 1=1
order by instr('A,C,B,E,D,F',区域)
产生对应序号
ROWINDEX | 区域 | S1 | S2 |
1 | A | ||
2 | C | ||
3 | B | ||
4 | E | ||
5 | D | ||
6 | F |