查询的同时 为记录加个序号或查到记录以后编个序号 怎么搞啊create table a
(
a varchar(10)
)insert into a values('a')
insert into a values('b')
insert into a values('c')
insert into a values('d')
insert into a values('e')select a from a结果为 a 1
b 2
c 3
d 4
e 5
(
a varchar(10)
)insert into a values('a')
insert into a values('b')
insert into a values('c')
insert into a values('d')
insert into a values('e')select a from a结果为 a 1
b 2
c 3
d 4
e 5
(
a varchar(10)
)insert into a values('a')
insert into a values('b')
insert into a values('c')
insert into a values('d')
insert into a values('e')select row_number() over(order by getdate()) no,a from a/*
no a
-------------------- ----------
1 a
2 b
3 c
4 d
5 e
select a,rowNum=(select count(1)+1 from a a1 where a1.a<a.a) from aselect a,identity(int,1,1) as id from a order by a--2005
select row_number() over(order by getdate()) no,a from a