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         COUNT(f1)
  13 ---------------------------------------------------------
  14         8
  15
  16 echo select min(f1) from t1;
  17 ---------------------------------------------------------
  18         MIN(f1)
  19 ---------------------------------------------------------
  20         1
  21
  22 echo select max(f3) from t1;
  23 ---------------------------------------------------------
  24         MAX(f3)
  25 ---------------------------------------------------------
  26         1000
  27
  28 echo select avg(f1) from t1;
  29 ---------------------------------------------------------
  30         AVG(f1)
  31 ---------------------------------------------------------
  32         165
  33
  34 echo select sum(f1) from t1;
  35 ---------------------------------------------------------
  36         SUM(f1)
  37 ---------------------------------------------------------
  38         1321
  39
  40 echo select count(f1) from t1 group by f2;
  41 ---------------------------------------------------------
  42         COUNT(f1)
  43 ---------------------------------------------------------
  44         3
  45         2
  46         2
  47         1
  48
  49 echo select min(f1) from t1 group by f2;
  50 ---------------------------------------------------------
  51         MIN(f1)
  52 ---------------------------------------------------------
  53         1
  54         5
  55         100
  56         1000
  57
  58 echo select max(f1) from t1 group by f2;
  59 ---------------------------------------------------------
  60         MAX(f1)
  61 ---------------------------------------------------------
  62         3
  63         10
  64         200
  65         1000
  66
  67 echo select avg(f1) from t1 group by f2;
  68 ---------------------------------------------------------
  69         AVG(f1)
  70 ---------------------------------------------------------
  71         2
  72         7
  73         150
  74         1000
  75
  76 echo select sum(f1) from t1 group by f2;
  77 ---------------------------------------------------------
  78         SUM(f1)
  79 ---------------------------------------------------------
  80         6
  81         15
  82         300
  83         1000
  84
  85 echo select min(f1), max(f3), sum(f1) from t1;
  86 ---------------------------------------------------------
  87         MIN(f1) MAX(f3) SUM(f1)
  88 ---------------------------------------------------------
  89         1       1000    1321
  90
  91 echo select min(f1), f2, max(f3) from t1;
  92 ---------------------------------------------------------
  93         MIN(f1) f2      MAX(f3)
  94 ---------------------------------------------------------
  95         1       1       1000
  96
  97 echo select min(f1), f2, max(f3) from t1 group by f2;
  98 ---------------------------------------------------------
  99         MIN(f1) f2      MAX(f3)
 100 ---------------------------------------------------------
 101         1       1       3
 102         5       2       10
 103         100     3       200
 104         1000    4       1000
 105
 106 echo select min(f2) from t1 group by f2;
 107 ---------------------------------------------------------
 108         MIN(f2)
 109 ---------------------------------------------------------
 110         1
 111         2
 112         3
 113         4
 114
 115 echo select count(*) from t1;
 116 ---------------------------------------------------------
 117         COUNT(*)
 118 ---------------------------------------------------------
 119         8
 120
 121 echo select count(*) from t1 group by f2;
 122 ---------------------------------------------------------
 123         COUNT(*)
 124 ---------------------------------------------------------
 125         3
 126         2
 127         2
 128         1
 129
 130 Statement Executed