如何给表加入一个标识号

Question

select field1,
       field2,
       field3=(select count(*) from A where A.field2<=aa.field2)
from A aa

Answer 1

select field1,
       field2,
       field3=(select count(*) from A where A.field1=aa.field1 and A.field2<=aa.field2)
into B
from A aa
order by aa.field1

Answer 2

select field1,field2,
       field3=(select count(*) from A where A.field2<=aa.field2)
from A aa
order by field1,field2,

Answer 3

THX!
zjcxc，你那个SQL少了个条件.