SQL Server Performance

Duplicate Value

Discussion in 'General DBA Questions' started by fauzanf, Jan 3, 2010.

  1. fauzanf New Member

    Hello My Friends,
    I want to know the SQL Syntax to find the duplicate value in one field of Table.
    Anybody can help me...?
    Thank you.
  2. Madhivanan Moderator

    SELECT col FROM yout_table
    GROUP BY col
    HAVING COUNT(col)>1

Share This Page