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
b@domain-----a----a
with the query:
Expand|Select|Wrap|Line Numbers
- SELECT email, q1, q2, q3, q4 FROM my_table
- GROUP BY email
- ORDER BY email
"Column 'mytable.q1' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause"
and this query gives every back without grouping:
Expand|Select|Wrap|Line Numbers
- SELECT email, q1, q2, q3, q4 FROM my_table
- GROUP BY email,q1,q2,q3,q4
- ORDER BY email
Thanx in advance.
Denitram