Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004

    Question Unanswered: Duplicate Records

    I have a table containing 5 Columns. One of the Column has duplicate records in it. I want to write a query which will give be records from all the columns for the duplicate data. Please help.
    Basically I want to exclude all the unique rows

  2. #2
    Join Date
    Mar 2004
    Greenville, SC

    More info

    You need to provide a little more info. What kind of data in the columns?
    Gotta to do some code

  3. #3
    Join Date
    Sep 2003
    The extremely Royal borough of Kensington, London
    select *
    from table
    where columnA IN
    (select columnA
    from table
    group by columnA
    having count(*) > 1);
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts