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.125000
  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.000000
  72         7.500000
  73         150.000000
  74         1000.000000
  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 Statement prepare failed with error -28
  93 echo select min(f1), f2, max(f3) from t1 group by f2;
  94 ---------------------------------------------------------
  95         MIN(f1) f2      MAX(f3)
  96 ---------------------------------------------------------
  97         1       1       3
  98         5       2       10
  99         100     3       200
 100         1000    4       1000
 101
 102 echo select min(f2) from t1 group by f2;
 103 ---------------------------------------------------------
 104         MIN(f2)
 105 ---------------------------------------------------------
 106         1
 107         2
 108         3
 109         4
 110
 111 echo select count(*) from t1;
 112 ---------------------------------------------------------
 113         COUNT(*)
 114 ---------------------------------------------------------
 115         8
 116
 117 echo select count(*) from t1 group by f2;
 118 ---------------------------------------------------------
 119         COUNT(*)
 120 ---------------------------------------------------------
 121         3
 122         2
 123         2
 124         1
 125
 126 Statement Executed