table t 包含
A int
B int
求个语句输入A,B,C,其中C为B在相同的A中的排序,比如
1,3
1,6
2,2
2,1
1,5
输出
1,3,1
1,6,3
2,2,2
2,1,1
1,5,2
------解决方案--------------------
create table T(a int,b int)
insert into T select 1,3
insert into T select 1,6
insert into T select 2,2
insert into T select 2,1
insert into T select 1,5
insert into T select 1,5
select a,b,(select count(distinct b) from T where a=TT.a and b <=TT.b) as c
from T as TT
order by a,b,c
drop table T
------解决方案--------------------
--加distinct即可
select a,b,(select count(distinct b) from T where a=TT.a and b <=TT.b) as c
from T as TT