查询SQL重复字段

select [name] from dbo.b_book  GROUP BY [name] having count(*)>1
posted @ 2009-03-18 13:36  悟〈--觉  阅读(311)  评论(1)  编辑  收藏  举报