例如数据:ColA ColB
1 H-W-H.
2 H-W-P~W~M-H.
3 H~P~H.
4 H-L-O-S-M~P-M~P-H.
5 ......查询“-”出现几次,结果:
ColA ColB Col C
1 H-W-H. 2
2 H-W-P~W~M-H. 3
3 H~P~H. 0
4 H-L-O-S-M~P-M~P-H. 6
5 ...... ..............
谢谢!
1 H-W-H.
2 H-W-P~W~M-H.
3 H~P~H.
4 H-L-O-S-M~P-M~P-H.
5 ......查询“-”出现几次,结果:
ColA ColB Col C
1 H-W-H. 2
2 H-W-P~W~M-H. 3
3 H~P~H. 0
4 H-L-O-S-M~P-M~P-H. 6
5 ...... ..............
谢谢!
from 表