test/sql/Aggregate/exp.testnw002.ksh

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