Displaying Duplicate entries

Discussion in 'Databases' started by sqldba, Feb 13, 2008.

0
  1. #1
    Hi,

    Please let me know how to find out or display only the duplicate entries in table.

    Thanks in advance
     
    sqldba, Feb 13, 2008 IP
  2. CreativeClans

    CreativeClans Peon

    Messages:
    128
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    SELECT field1, field2, field3, count(*)
    FROM tablename
    GROUP BY field1, field2, field3
    HAVING COUNT(*) > 1
     
    CreativeClans, Feb 13, 2008 IP