Contents tagged with SQL
-
Simple SQL query to get duplicate values in a table
This is simple T-SQL query to find duplicate values in Microsoft SQL Server Database
select a.field1, a.field2,a.field3, a.field4
from table a
where 1 < (select count(*)
from table b
where b.field1 = a.field1
and b.field2 = a.field2
and b.field3 = a.field3)