select distinct English,Meaning from dict 这个不对我找下看哈
select English,min(Meaning) from dict group by English
declare @T table(English varchar(20),Meaning varchar(40)) insert into @T select 'a', '一,一个' union all select 'a bit', '有点儿' union all select 'a bit', '有一点儿' union all select 'a bottle of', '一瓶' union all select 'a bottle of', '一瓶...' select * from @T select * from @t a where meaning=(select top 1 meaning from @T where english=a.english order by meaning)
--执行结果 a 一,一个 a bit 有点儿 a bottle of 一瓶
whbo(王红波(年轻人,要有所作为)) ( ) 你可能误解我的意思了!~ select English,min(Meaning) from dict group by English 这个是正确的
select English,min(Meaning) as Meaning Into Dictback from dict group by English 有了谢谢大家了哈
select distinct english,meaning from dict order by english,meaning
这个不对我找下看哈
insert into @T
select
'a', '一,一个'
union all
select
'a bit', '有点儿'
union all
select
'a bit', '有一点儿'
union all
select
'a bottle of', '一瓶'
union all
select
'a bottle of', '一瓶...'
select * from @T
select * from @t a where meaning=(select top 1 meaning from @T where english=a.english order by meaning)
a 一,一个
a bit 有点儿
a bottle of 一瓶
select English,min(Meaning) from dict group by English
这个是正确的
有了谢谢大家了哈