查询SQL重复字段

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