Donnerstag, 30. Mai 2013

T-SQL: Find double rows in a table

SELECT criticalFiled1, criticalFiled2, criticalFiled3, ..., COUNT(*)
FROM Table
GROUP BY criticalFiled1, criticalFiled2, criticalFiled3, ...
HAVING COUNT(*) > 1

1 Kommentar:

prasannasneha yadhavan hat gesagt…


Heya¡­my very first comment on your site. ,I have been reading your blog for a while and thought I would completely pop in and drop a friendly note. . It is great

stuff indeed. I also wanted to ask..is there a way to subscribe to your site via email?














IT Consulting