Application: gvSIG desktop

-- normalize-spaces true

-- strip-start true

-- remove-nl true

-- replace-nl-by-space true

-- trim-end true

-- begin count

SELECT COUNT(*) FROM "test"

-- end count

-- begin testAggregatesAndGroup

-- rem Count with aggregates and group SQL

SELECT COUNT(*) 

FROM ( SELECT MAX("test"."Byte") AS "Byte", 

             MIN("test"."ID") AS "ID", 

             SUM("test"."Double") AS "Double" 

      FROM "test" 

      GROUP BY "test"."Long") AS _subquery_alias_ 

-- end testAggregatesAndGroup

-- begin testGroup

-- rem Count with group SQL

SELECT COUNT(*) 

FROM ( SELECT "test"."Long" 

      FROM "test" 

      GROUP BY "test"."Long") AS _subquery_alias_ 

-- end testGroup

-- begin testAggregates

-- rem Count with aggregates

SELECT COUNT(*) 

FROM ( SELECT MAX("test"."Byte") AS "Byte", 

             MIN("test"."ID") AS "ID", 

             SUM("test"."Double") AS "Double" 

      FROM "test") AS _subquery_alias_ 

-- end testAggregates