test/tools/csql/exp.test029.ksh

   1 Statement Executed
   2 Statement Executed: Rows Affected = 1
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed: Rows Affected = 1
   8 Statement Executed: Rows Affected = 1
   9 Statement Executed: Rows Affected = 1
  10 echo select count(f1) from t1;
  11 ---------------------------------------------------------
  12
  13 ---------------------------------------------------------
  14         8
  15
  16 echo select min(f1) from t1;
  17 ---------------------------------------------------------
  18
  19 ---------------------------------------------------------
  20         1
  21
  22 echo select max(f3) from t1;
  23 ---------------------------------------------------------
  24
  25 ---------------------------------------------------------
  26         1000
  27
  28 echo select avg(f1) from t1;
  29 ---------------------------------------------------------
  30
  31 ---------------------------------------------------------
  32         165
  33
  34 echo select sum(f1) from t1;
  35 ---------------------------------------------------------
  36
  37 ---------------------------------------------------------
  38         1321
  39
  40 echo select count(f1) from t1 group by f2;
  41 ---------------------------------------------------------
  42
  43 ---------------------------------------------------------
  44         3
  45         2
  46         2
  47         1
  48
  49 echo select min(f1) from t1 group by f2;
  50 ---------------------------------------------------------
  51
  52 ---------------------------------------------------------
  53         1
  54         5
  55         100
  56         1000
  57
  58 echo select max(f1) from t1 group by f2;
  59 ---------------------------------------------------------
  60
  61 ---------------------------------------------------------
  62         3
  63         10
  64         200
  65         1000
  66
  67 echo select avg(f1) from t1 group by f2;
  68 echo select sum(f1) from t1 group by f2;
  69 ---------------------------------------------------------
  70
  71 ---------------------------------------------------------
  72         6
  73         15
  74         300
  75         1000
  76
  77 echo select min(f1), max(f3), sum(f1) from t1;
  78 ---------------------------------------------------------
  79
  80 ---------------------------------------------------------
  81         1       1000    1321
  82
  83 echo select min(f1), f2, max(f3) from t1;
  84 ---------------------------------------------------------
  85
  86 ---------------------------------------------------------
  87         1       4       1000
  88
  89 echo select min(f1), f2, max(f3) from t1 group by f2;
  90 ---------------------------------------------------------
  91
  92 ---------------------------------------------------------
  93         1       1       3
  94         5       2       10
  95         100     3       200
  96         1000    4       1000
  97
  98 echo select min(f2) from t1 group by f2;
  99 select min(f2) from t1 group by f2;
 100 echo select count(*) from t1;
 101 echo select count(*) from t1 group by f2;