|
Posted by getinked on 11/22/05 00:58
Its not so much in the case statement. The group by clause is where
the logic was out of place in your query. if you add the age field to
the group by in my query you will get the result set you had previous.
In the case statement if you dont specify a value for the other records
it just skips them, but the way i wrote it, if yoiu have say age 19 you
will get two records so you have to specify all the ages. if you want
an all inclusive statement to cover x age you would have to write it a
little different.
cheers
Navigation:
[Reply to this message]
|