January 11, 2008 at 8:29 am
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.
January 11, 2008 at 8:40 am
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. SelburgJanuary 11, 2008 at 8:43 am
The answer is yes.
January 11, 2008 at 9:42 am
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