Group By

[VBXL]

Hi,

When i run a group by statement

i.e group by substring(example,1,3), example2

it still lists duplicate values ie.

example example2
aaaaa 22
aaaaa 345
bbbbb 111
bbbbb 323
bbbbb 5566

Any way around this. I just want to group by the first 6 char's of 'example'

VBXL

 

[balves]

You are grouping by 2 fields, so they are not duplicates.