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

History | View | Annotate | Download (279 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(*) 


    		
  

  

    
      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