Subject Re: GROUP BY odd results - can someone explain please?
Thanks for the replies.

- Same results with ISQL + CTE
-  FB version SS on Windows 2008 Server R2 (on a VM)
- will validate the db when possible.

Database info 
ODS Version 11.1
Page Size 8192
Pages 163560
Size on Disk 1.25GB
SQL Dialect 3
Default Character Set NONE
Page Buffers 10000
Sweep Interval 0
Forced Writes Y
Reserve Space Y
Read-Only N

Transaction info
Oldest transaction 63483321
Oldest active transaction 63483322
Oldest snapshot 63483322
Next transaction 63483378