test/jdbc/Statement/exp.test024.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 Statement Executed: Rows Affected = 1
  11 Statement Executed: Rows Affected = 1
  12 echo Select f1,f5 from T1 order by f1;
  13 ---------------------------------------------------------
  14         f1      f5
  15 ---------------------------------------------------------
  16         100     6000.000000
  17         100     4000.000000
  18         100     1000.000000
  19         200     7000.000000
  20         200     5000.000000
  21         200     2000.000000
  22         300     8000.000000
  23         300     3000.000000
  24         400     5000.000000
  25         1000    9000.000000
  26
  27 SELECT T1.f1,AVG(T1.f5) FROM T1 GROUP BY T1.f1;
  28 T1.f1   AVG(T1.f5)
  29 100     3666.6666666666665
  30 200     4666.666666666667
  31 300     5500.0
  32 400     5000.0
  33 1000    9000.0
  34 SELECT f1,AVG(f5) FROM T1 GROUP BY f1 HAVING AVG(f5)>5000;
  35 T1.f1   AVG(T1.f5)
  36 300     5500.0
  37 1000    9000.0
  38 SELECT f1,AVG(f5) FROM T1 WHERE f1>200 GROUP BY f1;
  39 T1.f1   AVG(T1.f5)
  40 300     5500.0
  41 400     5000.0
  42 1000    9000.0
  43 SELECT f1,AVG(f5) FROM T1 WHERE f1> 100 GROUP BY f1 HAVING AVG(f5)>5000;
  44 T1.f1   T1.f2   AVG(T1.f5)
  45 300     5500.0
  46 1000    9000.0