-- begin count SELECT COUNT(*) FROM "PUBLIC"."test" -- end count -- begin SimpleGroup -- rem Count with group SQL SELECT COUNT(*) FROM ( SELECT COUNT(*) FROM "PUBLIC"."test" GROUP BY "Long" ORDER BY "Long" ASC ) as _subquery_alias_ -- end SimpleGroup