Statistics
| Revision:

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 @ 46505

History | View | Annotate | Download (356 Bytes)

1 

    		
  

  

    
      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(*) FROM ( SELECT MAX("PUBLIC"."test"."Byte") AS "Byte", MIN("PUBLIC"."test"."ID") AS "ID", SUM("PUBLIC"."test"."Double") AS "Double" FROM "PUBLIC"."test" GROUP BY "PUBLIC"."test"."Long") as _subquery_alias_ 


    		
  

  

    
      9
    
    
      
-- end SimpleGroup