Application: gvSIG desktop

-- ResultSetForSetProvider SQL

-- Simple

SELECT 

    "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", 

    "Bool2", "String", "Bool3", "Double", "Bool4", "Float", "Bool5", "Decimal", 

    NVL2("Geometry",ST_AsBinary("Geometry"),NULL) 

  FROM "PUBLIC"."test";

-- Simple Group by

SELECT 

    MIN("ID") AS "ID", MAX("Byte") AS "Byte", NULL AS "Bool1", "Long", 

    NULL AS "Timestamp", NULL AS "Date", NULL AS "Time", NULL AS "Bool2", 

    NULL AS "String", NULL AS "Bool3", SUM("Double") AS "Double", 

    NULL AS "Bool4", NULL AS "Float", NULL AS "Bool5", NULL AS "Decimal", 

    NULL AS "Geometry" 

  FROM "PUBLIC"."test" 

  GROUP BY "Long";

-- Subselect

SELECT 

    "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", "Bool2", 

    "String", "Bool3", "Double", "Bool4", "Float", "Bool5", "Decimal", 

    NVL2("Geometry",ST_AsBinary("Geometry"),NULL), 

    NVL2(COALESCE((

      SELECT "ISO_A2" 

      FROM "countries" 

      WHERE (("TEST"."STRING" = "countries"."CONTINENT") AND 

        ("countries"."LASTCENSUS" < 0)) LIMIT 1)),TRUE,FALSE) 

    AS "EXISTS62a964cd7bc24f409b97c03b9170408d" 

  FROM "PUBLIC"."test" 

  WHERE NVL2(COALESCE((

    SELECT "ISO_A2" 

    FROM "countries" 

    WHERE (("TEST"."STRING" = "countries"."CONTINENT") AND 

      ("countries"."LASTCENSUS" < 0)) LIMIT 1)),TRUE,FALSE);