test/sql/Aggregate/exp.testnw001.ksh

   1 Network CSql
   2 echo select count(f1) from t2;
   3 Statement prepare failed with error -5
   4 echo select count(f1) from t1;
   5 ---------------------------------------------------------
   6         COUNT(f1)
   7 ---------------------------------------------------------
   8         5
   9
  10 echo select sum(f1) from t1;
  11 ---------------------------------------------------------
  12         SUM(f1)
  13 ---------------------------------------------------------
  14         500
  15
  16 echo select avg(f1) from t1;
  17 ---------------------------------------------------------
  18         AVG(f1)
  19 ---------------------------------------------------------
  20         100.000000
  21
  22 echo select min(f1) from t1;
  23 ---------------------------------------------------------
  24         MIN(f1)
  25 ---------------------------------------------------------
  26         98
  27
  28 echo select max(f1) from t1;
  29 ---------------------------------------------------------
  30         MAX(f1)
  31 ---------------------------------------------------------
  32         102
  33