I have a sql sentence is "SELECT sum(new_int)-count(*) from new_tbl". I can use it in Oracle and SQLSERVER,but when i used it in Hypersonic, the system told me "The unexpected error Count..".How can i solve the problem? Should i use sql sentences like that in Hypersonic? I have tried the sql as "(sum(new_int)-count(*)) AS 'a'",but system told me wrong again.
Previous Topic
