svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.plugin / org.gvsig.h2spatial / org.gvsig.h2spatial.h2gis132 / org.gvsig.h2spatial.h2gis132.provider / src / test / resources / org / gvsig / fmap / dal / store / h2 / count.sql @ 46517
History | View | Annotate | Download (1.03 KB)
1 |
|
---|---|
2 |
-- normalize-spaces true
|
3 |
-- strip-start true
|
4 |
-- remove-nl true
|
5 |
-- replace-nl-by-space true
|
6 |
-- trim-end true
|
7 |
|
8 |
-- begin count
|
9 |
SELECT COUNT(*) FROM "PUBLIC"."test" |
10 |
-- end count
|
11 |
|
12 |
-- begin testAggregatesAndGroup
|
13 |
-- rem Count with aggregates and group SQL
|
14 |
SELECT COUNT(*) |
15 |
FROM ( SELECT MAX("PUBLIC"."test"."Byte") AS "Byte", |
16 |
MIN("PUBLIC"."test"."ID") AS "ID", |
17 |
SUM("PUBLIC"."test"."Double") AS "Double" |
18 |
FROM "PUBLIC"."test" |
19 |
GROUP BY "PUBLIC"."test"."Long") AS _subquery_alias_ |
20 |
-- end testAggregatesAndGroup
|
21 |
|
22 |
-- begin testGroup
|
23 |
-- rem Count with group SQL
|
24 |
SELECT COUNT(*) |
25 |
FROM ( SELECT "PUBLIC"."test"."Long" |
26 |
FROM "PUBLIC"."test" |
27 |
GROUP BY "PUBLIC"."test"."Long") AS _subquery_alias_ |
28 |
-- end testGroup
|
29 |
|
30 |
-- begin testAggregates
|
31 |
-- rem Count with aggregates
|
32 |
SELECT COUNT(*) |
33 |
FROM ( SELECT MAX("PUBLIC"."test"."Byte") AS "Byte", |
34 |
MIN("PUBLIC"."test"."ID") AS "ID", |
35 |
SUM("PUBLIC"."test"."Double") AS "Double" |
36 |
FROM "PUBLIC"."test") AS _subquery_alias_ |
37 |
-- end testAggregates
|
38 |
|