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.txt @ 46102
History | View | Annotate | Download (279 Bytes)
1 | 46102 | jjdelcerro | |
---|---|---|---|
2 | -- begin count |
||
3 | SELECT COUNT(*) FROM "PUBLIC"."test" |
||
4 | -- end count |
||
5 | |||
6 | -- begin SimpleGroup |
||
7 | -- rem Count with group SQL |
||
8 | SELECT COUNT(*) |
||
9 | FROM ( |
||
10 | SELECT COUNT(*) |
||
11 | FROM "PUBLIC"."test" |
||
12 | GROUP BY "Long" |
||
13 | ORDER BY "Long" ASC |
||
14 | ) as _subquery_alias_ |
||
15 | -- end SimpleGroup |