Subject GROUP BY odd results - can someone explain please?
Author

e.g. 

I was expecting to see one row for 

"melvin comms directors 30.04.13" and also for "DCFTG210513".


TIA

Tom


QUERY

-----

select '['|| TRIM(SUBSTRING(COMMENTS FROM 1 FOR 100)) || ']', count(*)

from target

group by 1

having count(*)>5

order by 1


RESULTS

-------

[null] 2289

[melvin comms directors 30.04.13] 17

[melvin comms directors 30.04.13] 52

[melvin comms directors 30.04.13] 18

[melvin comms directors 30.04.13] 8

[melvin comms directors 30.04.13] 6

[DCFTG210513] 14

[Rackable/SGI] 10

[microsoft james 15.03] 15

[microsoft james 15.03] 8

[NWSEI060613] 6

[DCFTG210513] 19

[DCFTG210513] 19

[lifesiences] 7

[DCFTG210513] 37

[DCFTG210513] 17

....