test/tools/csql/exp.testnw017.ksh

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