Archives

• Simple SQL query to get duplicate values in a table

  Thursday, September 11, 2008

  Query SQL

  28 Comments

  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)
  

  Read more...