Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    1

    Unanswered: select multiple occurances

    I have a table
    table - col1, col2

    I want to select those records which have multiple occurances of same combination of col1 and col2.
    i.e.

    Table
    -------------
    col1 col2
    ---------------
    a a
    a b
    b c
    a a

    I want to select the records having a combination of (a,a)

  2. #2
    Join Date
    May 2002
    Location
    Vancouver Canada
    Posts
    26
    SELECT * FROM Table WHERE col1 = col2

Posting Permissions

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