将“多对多”改为“一对多”(change “many-to-many” to “one-to-many”)

 我有以下表格和数据： 
 
create table Foo
(
    id int not null,
    hid int not null,
    value int not null
)

insert into Foo(id, hid, value) values(1,1,1) -- use this as 1 < 3
insert into Foo(id, hid, value) values(1,2,3)

insert into Foo(id, hid, value) values(2,3,3) -- use this as 3 < 5
insert into Foo(id, hid, value) values(2,4,5)

insert into Foo(id, hid, value) values(3,2,2) -- use this or next one as value are the same
insert into Foo(id, hid, value) values(3,3,2)
 
 目前，“id”和“hid”具有多对多的关联关系，我想要实现的是将“hid”设置为“one”而不是“many”，规则是使用最小的“value”该表，请参阅上面的sql代码中的注释。 
 
 这可能使用一些查询来实现这个而不是游标？ 
 
 谢谢！ 

I have following table and data:
 
create table Foo
(
    id int not null,
    hid int not null,
    value int not null
)

insert into Foo(id, hid, value) values(1,1,1) -- use this as 1 < 3
insert into Foo(id, hid, value) values(1,2,3)

insert into Foo(id, hid, value) values(2,3,3) -- use this as 3 < 5
insert into Foo(id, hid, value) values(2,4,5)

insert into Foo(id, hid, value) values(3,2,2) -- use this or next one as value are the same
insert into Foo(id, hid, value) values(3,3,2)
 
Currently the "id" and "hid" has many-to-many association, what I want to achieve is to make the "hid" as "one" instead of "many", the rule is to use the minimum "value" in the table, see comment in above sql code.
 
Is this possible use some query to achieve this instead of a cursor?
 
Thanks!

原文：https://stackoverflow.com/questions/2024819