create table B (name varchar(10), number int) insert into b select 'a', 1 insert into b select 'b', 2 insert into b select 'c', 3 insert into b select 'd', 4update b set number=(select count(*)+1 from b as b2 where b1.name>b2.name) from b as b1
没有关系,那你来贴两个表干嘛?Select name,number-6 as number from 表B
create table B (name varchar(10), number int)
insert into b select 'a', 1
insert into b select 'b', 2
insert into b select 'c', 3
insert into b select 'd', 4update b
set number=(select count(*)+1 from b as b2 where b1.name>b2.name)
from b as b1