标题:如何把具有相同字段的记录删除,只留一条
只看楼主
Kendy123456
Rank: 10Rank: 10Rank: 10
等 级:贵宾
威 望:62
帖 子:2720
专家分:0
注 册:2007-1-3
得分:0 
delete test where id not in (select name,max(id) from test group by name)

[此贴子已经被作者于2007-1-11 17:00:41编辑过]


2007-01-11 12:02



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-115072-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.011022 second(s), 7 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved