Results 1 to 3 of 3

Thread: Duplicate rows

  1. #1
    Join Date
    Jan 2003
    Location
    Chennai
    Posts
    4

    Unanswered: Duplicate rows

    Hello ,
    I have Table ( T)
    It has cols (A,B,C,D,...)
    The cols (A,B) combinedly form the primary key for the table 'T'
    The problem is I need to know all the duplicate rows formed by A,C
    How could I do it? , can I do through a query or shall I go for
    appl program

    Thanks in advance


    kalyan

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    select A, C
    from yourtable
    group by A, C
    having count(*) > 1


    rudy

  3. #3
    Join Date
    Jan 2003
    Location
    Chennai
    Posts
    4
    Originally posted by r937
    select A, C
    from yourtable
    group by A, C
    having count(*) > 1


    rudy
    Thank you Rudy

Posting Permissions

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