insert table2(Item,Vender,Description)
select Item,Vender,Description
from table1 a
where Vender=(select min(Vender) from table1 where item=a.item)
and Description=(select min(Description) from table1 where item=a.item and Vender=a.Vender)
select Item,Vender,Description
from table1 a
where Vender=(select min(Vender) from table1 where item=a.item)
and Description=(select min(Description) from table1 where item=a.item and Vender=a.Vender)
insert table2 select Item,Vender,Description from table1 a
where vender = (select min(vender) from table1 where Item = a.Item)
select Item , Vender , Description from table1 as b,
( select distinct art item from table1 ) as a
where b.art = a. art and b. item = a.item
select Item,Vender,Description
from table1 a
where not exists (select 1 from table1 where item=a.item and a.art<art)
where vender = (select min(vender) from table1 where Item = a.Item)insert table2 select Item,Vender,[Description] from table1 a where vender = (select top 1 vender from table1 where Item = a.Item)两句insert中,当vender为字符型时,结果数不正确(重复的也显示出来了);数字型时却可以,我最初以为min()中的才会这样,谁知 top 1的也会这样,怎解呢?