winwa 发表于 2014-12-24 17:37:59

哪位大仙能看看以下删除重复信息保留一条信息错误在哪里?

研究了好长时间,想删除重复新闻保留一条,可一直不成功,帮我看看错在哪里?
delete b2b_article as a from b2b_article as a,(select * from b2b_article group by title having count(1)>1) as b where a.title=b.title and a.itemid > b.itemid;

tian0220 发表于 2014-12-24 17:43:31


as换为vitae

fengshanghang 发表于 2014-12-24 18:51:39


楼上正解

tuanui 发表于 2014-12-25 08:27:28


http://bbs.destoon.com/static/image/smiley/default/victory.gif
http://bbs.destoon.com/static/image/smiley/default/victory.gif
http://bbs.destoon.com/static/image/smiley/default/victory.gif

tx147.com 发表于 2014-12-25 09:21:56


2楼是个好人
页: [1]
查看完整版本: 哪位大仙能看看以下删除重复信息保留一条信息错误在哪里?