34,838
社区成员




create table TA(ID1 numeric(18,0), ID2 numeric(18,0), dist float)
insert TA
select 10001, 11101, 0.01
union all select 10001, 11102, 0.21
union all select 10001, 11103, 0.31
union all select 10001, 11104, 0.41
union all select 10001, 11105, 0.36
union all select 10002, 11101, 0.12
union all select 10002, 11102, 0.32
union all select 10002, 11103, 0.52
union all select 10002, 11104, 0.72
union all select 10002, 11105, 0.68
union all select 10003, 11101, 0.23
union all select 10003, 11102, 0.43
union all select 10003, 11103, 0.63
union all select 10003, 11104, 0.83
union all select 10003, 10005, 0.77
union all select 10004, 11101, 0.64
union all select 10004, 11102, 0.44
union all select 10004, 11103, 0.24
union all select 10004, 11104, 0.14
union all select 10004, 11105, 0.22
union all select 10005, 11101, 0.18
union all select 10005, 11102, 0.33
union all select 10005, 11103, 0.37
union all select 10005, 11104, 0.48
union all select 10005, 11105, 0.88