Hi Thomas, This query
SELECT count(name) as c FROM mytable having count(name) = 1 should return names exactly once from the table but it returns 0 where I know there are many names that are not duplicate. Also, SELECT count(*) as c,cat1,cat2,cat3 FROM mytable where cat1 is not null group by cat1,cat2,cat3 order by cat1.cat2 Notice order by, where by mistake I typed dot instead of comma and it works too ! I am using H2 v 1.2.147 Warm regards, Nitin -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
