求一条Select语句~~

[咏帆]

有一个表dict
中有这二个字段：English,Meaning
有这些记录
English Meaning
a 一，一个
a bit 有点儿
a bit 有一点儿
a bottle of 一瓶
a bottle of 一瓶...
...
怎么样去掉这些类似记录中的一条
得到下列结果
English Meaning
a 一，一个
a bit 有点儿
a bottle of 一瓶

[咏帆]

路过的帮忙看下呀

在线等

[zhouhaihe]

select English, Meaning
from dict
group by English, Meaning
order by English

[咏帆]

结果不对呀

还是跟原来的一样

[面包]

你去找找关于删除重复记录的帖子，有很多的


============================================
吾本貴公子，平生實愛才；
感時思報國，拔劍起藁萊。
西馳丁零塞，北上單于台；
登山見千里，懷古心憂哉。
誰言未忘禍，磨滅成塵埃！

[tony_ht]

select distinct English,Meaning from dict

[咏帆]

select distinct English,Meaning from dict


这个不对

我找下看哈

[tony_ht]

对不起,上面写的不对.

[hfyang9095]

select English,min(Meaning) from dict group by English

[tony_ht]

楼上的正解,学习中...

[todouwang]

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)

[todouwang]

--执行结果
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


有了

谢谢大家了哈

[mislrb]

select distinct english,meaning from dict order by english,meaning