denitram
Last Activity: Mar 21 '07, 09:31 AM
Joined: Feb 14 '07
Location:
-
Thank you a lot, it's working... -
MS-SQL question about GROUP BY
Hi,
I have a table that has email, q1,q2 etc. I would like to select each email and the result should have each email listed once with the values of q1,q2,q3 & q4.
For example:
email-------------q1---q2
a@domain-----a
b@domain-----a
a@domain-------------b
b@domain-------------a
the result should be:
email------------q1---q2
a@domain-----a----b
...
No activity results to display
Leave a comment: