Brain Teaser

  • Is there a way to return a result set where a number is encountered only once in a table.

    Table1

    ------

    Num1Num2Connection

    ------------------

    12Con1

    23Con2

    24Con3

    35Con4

    45Con5

    46Con6

    I want to return a data set with only (1, 3) based solely on the fact that they only appear once in Column Num1.

  • Homework?

    Read up on HAVING in BOL.

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • The answer is yes.

  • HAVING worked...thank you.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply