原有一表结构:
ID ZiFu(varchar(100))
1 AABBABBABABBBB
2 BAAAAAABBBBAAAAAABBBBBBBAAAABABA
3 BABABABABABABABABAABABABABABABABABABABABABABBBBBBBABABAB
. .
. .
10000 BBBABABABABBBBBABABABABBBABABABABABBBA
========================
我想ZiFu项都可以是有ID类的列值把顺序标出来。请教如何实现。
ID ZiFu(varchar(100))
1 AABBABBABABBBB
2 BAAAAAABBBBAAAAAABBBBBBBAAAABABA
3 BABABABABABABABABAABABABABABABABABABABABABABBBBBBBABABAB
. .
. .
10000 BBBABABABABBBBBABABABABBBABABABABABBBA
========================
我想ZiFu项都可以是有ID类的列值把顺序标出来。请教如何实现。
1 A A B B A B B A B A B B B B
2 B A A A A A A B B B B A A A A A A B B B B B B B A A A A B A B A
3 B A B A B A B A B A B A B A B A B A A B A B A B A B A B A B A B A B A B A B A B A B A B B B B B B B A B A B A B
. .
. .
10000 B B B A B A B A B A B B B B B A B A B A B A B B B A B A B A B A B A B B B A
sql如果要实现的话是否是通过关联查询实现