Revision 916 org.gvsig.oracle/trunk/org.gvsig.oracle/org.gvsig.oracle.provider/src/test/resources/org/gvsig/oracle/dal/operations/sql/count.sql
| count.sql | ||
|---|---|---|
| 10 | 10 |
|
| 11 | 11 |
|
| 12 | 12 |
-- begin count |
| 13 |
SELECT COUNT(*) FROM "P1"."test"
|
|
| 13 |
SELECT COUNT(*) FROM "P1"."TEST"
|
|
| 14 | 14 |
-- end count |
| 15 | 15 |
|
| 16 | 16 |
-- begin testAggregatesAndGroup |
| 17 | 17 |
-- rem Count with aggregates and group SQL |
| 18 | 18 |
SELECT COUNT(*) |
| 19 | 19 |
FROM ( |
| 20 |
SELECT MAX("P1"."test"."Byte") "Byte",
|
|
| 21 |
MIN("P1"."test"."ID") "ID",
|
|
| 22 |
SUM("P1"."test"."Double") "Double"
|
|
| 23 |
FROM "P1"."test"
|
|
| 24 |
GROUP BY "P1"."test"."Long") "_subquery_alias_"
|
|
| 20 |
SELECT MAX("P1"."TEST"."Byte") "Byte",
|
|
| 21 |
MIN("P1"."TEST"."ID") "ID",
|
|
| 22 |
SUM("P1"."TEST"."Double") "Double"
|
|
| 23 |
FROM "P1"."TEST"
|
|
| 24 |
GROUP BY "P1"."TEST"."Long") "_subquery_alias_"
|
|
| 25 | 25 |
-- end testAggregatesAndGroup |
| 26 | 26 |
|
| 27 | 27 |
-- begin testGroup |
| 28 | 28 |
-- rem Count with group SQL |
| 29 | 29 |
SELECT COUNT(*) |
| 30 |
FROM ( SELECT "P1"."test"."Long"
|
|
| 31 |
FROM "P1"."test"
|
|
| 32 |
GROUP BY "P1"."test"."Long") "_subquery_alias_"
|
|
| 30 |
FROM ( SELECT "P1"."TEST"."Long"
|
|
| 31 |
FROM "P1"."TEST"
|
|
| 32 |
GROUP BY "P1"."TEST"."Long") "_subquery_alias_"
|
|
| 33 | 33 |
-- end testGroup |
| 34 | 34 |
|
| 35 | 35 |
-- begin testAggregates |
| 36 | 36 |
-- rem Count with aggregates |
| 37 | 37 |
SELECT COUNT(*) |
| 38 |
FROM ( SELECT MAX("P1"."test"."Byte") "Byte",
|
|
| 39 |
MIN("P1"."test"."ID") "ID",
|
|
| 40 |
SUM("P1"."test"."Double") "Double"
|
|
| 41 |
FROM "P1"."test") "_subquery_alias_"
|
|
| 38 |
FROM ( SELECT MAX("P1"."TEST"."Byte") "Byte",
|
|
| 39 |
MIN("P1"."TEST"."ID") "ID",
|
|
| 40 |
SUM("P1"."TEST"."Double") "Double"
|
|
| 41 |
FROM "P1"."TEST") "_subquery_alias_"
|
|
| 42 | 42 |
-- end testAggregates |
| 43 | 43 |
|
Also available in: Unified diff