test/sql/Aggregate/exp.test002.ksh

   1 echo select count(f1) from t1;
   2 ---------------------------------------------------------
   3         COUNT(t1.f1)
   4 ---------------------------------------------------------
   5         5
   6
   7 echo select count(*) from t1 where f4='AAA';
   8 ---------------------------------------------------------
   9         COUNT(*)
  10 ---------------------------------------------------------
  11         2
  12
  13 echo select sum(f1) from t1;
  14 ---------------------------------------------------------
  15         SUM(t1.f1)
  16 ---------------------------------------------------------
  17         500
  18
  19 echo select avg(f1) from t1;
  20 ---------------------------------------------------------
  21         AVG(t1.f1)
  22 ---------------------------------------------------------
  23         100.000000
  24
  25 echo select min(t1.f1) from t1;
  26 ---------------------------------------------------------
  27         MIN(t1.f1)
  28 ---------------------------------------------------------
  29         98
  30
  31 echo select min(f4) from t1;
  32 ---------------------------------------------------------
  33         MIN(f4)
  34 ---------------------------------------------------------
  35         AAA
  36
  37 echo select max(t1.f1) from t1;
  38 ---------------------------------------------------------
  39         MAX(t1.f1)
  40 ---------------------------------------------------------
  41         102
  42
  43 echo select max(f4) from t1;
  44 ---------------------------------------------------------
  45         MAX(f4)
  46 ---------------------------------------------------------
  47         CCC
  48