Home Forums SQL Server 2008 SQL Server Newbies How to fetch duplicate records RE: How to fetch duplicate records

  • January 23, 2013 at 4:12 am

    #1579993

    select <field list req'd>

    from <your table>

    where <field with dupes> in (select <field with dupes> from <your table> group by <field with dupes>

    having count(*) > 1)