Revision 44951 trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.mdb/src/test/resources/org/gvsig/fmap/dal/store/mdb/count.sql

View differences:

count.sql
1 1 

  		




  2
  2
  
    
-- Count SQL


  		




  3
  
  
    
SELECT COUNT(*) FROM "PUBLIC"."test";


  		




  
  3
  
    
SELECT COUNT(*) FROM [test];


  		




  4
  4
  
    

  		




  5
  5
  
    
-- Count with group SQL


  		




  6
  6
  
    
SELECT COUNT(*) 


  		




  7
  7
  
    
  FROM ( 


  		




  8
  8
  
    
    SELECT COUNT(*) 


  		




  9
  
  
    
    FROM "PUBLIC"."test" 


  		




  10
  
  
    
    GROUP BY "Long" 


  		




  11
  
  
    
    ORDER BY "Long" ASC


  		




  
  9
  
    
    FROM [test] 


  		




  
  10
  
    
    GROUP BY [Long] 


  		




  
  11
  
    
    ORDER BY [Long] ASC


  		




  12
  12
  
    
  ) as _subquery_alias_ ;


  		












Also available in:  Unified diff