use db --SELECT [×Ö¶Î] FROM [±í] GROUP BY [×Ö¶Î] HAVING COUNT([×Ö¶Î]) > 1 --SELECT COUNT(name) FROM syscolumns WHERE id=object_id('dindan') select * from dindansp where id in(select id from dindansp group by id having count(id) > 1) order by id
