-- begin count SELECT COUNT(*) FROM "PUBLIC"."test" -- end count -- begin SimpleGroup -- rem Count with group SQL SELECT COUNT(*) FROM ( SELECT MAX("PUBLIC"."test"."Byte") AS "Byte", MIN("PUBLIC"."test"."ID") AS "ID", SUM("PUBLIC"."test"."Double") AS "Double" FROM "PUBLIC"."test" GROUP BY "PUBLIC"."test"."Long") as _subquery_alias_ -- end SimpleGroup