try:
Select aa.*
From @a aa
Join
(Select name,min(number) as number from @a ) bb
on aa.name = bb.name and aa.number = bb.number
Select aa.*
From @a aa
Join
(Select name,min(number) as number from @a ) bb
on aa.name = bb.name and aa.number = bb.number
insert @a select '201',1000,1.5,'只'
union select '201',100,1.5,'小件'
union select '201',1,1.5,'大件'
union select '301',1000,0.5,'只'
union select '301',10,0.5,'千克'Select aa.*
From @a aa
Join
(Select name,min(number) as number from @a group by name ) bb
on aa.name = bb.name and aa.number = bb.number
(所影响的行数为 5 行)name number price unit
-------------------------------------------------- -------------------- -------------------- ----------
201 1.0000 1.5000 大件
301 10.0000 .5000 千克(所影响的行数为 2 行)