--SQL Sever2000 序号,还是个热的.
declare @t table (f1 int, f2 varchar(20))
insert into @t select 21,'A1'
union all select 19,'A6'
union all select 40,'A4'
union all select 20,'A6'
select 序号=(select sum(1) from @t where convert(varchar(10),f1)+convert(varchar(10),f2)<=
convert(varchar(10),a.f1)+convert(varchar(10),a.f2)),
f1,f2
from @t a
order by 序号--结果
序号 f1 f2
----------- ----------- --------------------
1 19 A6
2 20 A6
3 21 A1
4 40 A4(所影响的行数为 4 行)
declare @t table (f1 int, f2 varchar(20))
insert into @t select 21,'A1'
union all select 19,'A6'
union all select 40,'A4'
union all select 20,'A6'
select 序号=(select sum(1) from @t where convert(varchar(10),f1)+convert(varchar(10),f2)<=
convert(varchar(10),a.f1)+convert(varchar(10),a.f2)),
f1,f2
from @t a
order by 序号--结果
序号 f1 f2
----------- ----------- --------------------
1 19 A6
2 20 A6
3 21 A1
4 40 A4(所影响的行数为 4 行)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货