这个SQL怎么写

[wanglh]

数据库中有表TA
TA
-------------
A B


字段类型A字符串，B整形
要求是：
返回TA中的A，B及C（一数值计算结果）
C的值计算方法是此表中小于当前B的数量
不能用分组，返回的行数等于TA中所有的行数

[pengdali]

select *,(select sum(1) from ta wehre b<=tem.b) c from ta tem

[pengdali]

select *,(select sum(1) from ta wehre b<tem.b) c from ta tem

[hjb111]

不需要分组：
select *,(select sum(1) from TA wehre b<T.b) c from TA as T

[wanglh]

1

[wstorm]

select *,(select sum(1) from ta wehre b<A.b) c from ta A

[maoyesky]

select *, (select isnull(sum(1),0) from TA where b < t.b) c from TA as t