test/sql/Limit/exp.test004.ksh

   1 echo CREATE TABLE t1(f1 int, f2 char(10), f3 date, f4 BIGINT);
   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 Statement Executed: Rows Affected = 1
  12 Statement Executed: Rows Affected = 1
  13 Statement Executed: Rows Affected = 1
  14 Statement Executed: Rows Affected = 1
  15 Statement Executed: Rows Affected = 1
  16 Statement Executed: Rows Affected = 1
  17 Statement Executed: Rows Affected = 1
  18 echo SELECT * FROM t1;
  19 ---------------------------------------------------------
  20         t1.f1   t1.f2   t1.f3   t1.f4
  21 ---------------------------------------------------------
  22         1       ABCD    2009/8/1        50
  23         3       BCDA    2009/8/2        60
  24         5       CDBA    2009/8/3        70
  25         3       DCBA    2009/8/9        80
  26         4       ACBD    2009/8/7        10
  27         1       PQRS    2009/8/2        20
  28         2       TUVW    2009/8/3        30
  29         3       EFGH    2009/8/4        40
  30         4       IJKL    2009/8/7        50
  31         5       MNOP    2009/8/8        10
  32         4       MMMM    2009/8/2        40
  33         3       NNNN    2009/8/3        50
  34         2       OOOO    2009/8/4        20
  35         1       PPPP    2009/8/7        30
  36         2       QQQQ    2009/8/8        50
  37
  38 echo SELECT f1,MAX(f3) FROM t1 GROUP BY f1;
  39 ---------------------------------------------------------
  40         f1      MAX(f3)
  41 ---------------------------------------------------------
  42         1       2009/8/7
  43         3       2009/8/9
  44         5       2009/8/8
  45         4       2009/8/7
  46         2       2009/8/8
  47
  48 echo SELECT f1,COUNT(f3) FROM t1 GROUP BY f1 LIMIT 3;
  49 ---------------------------------------------------------
  50         f1      COUNT(f3)
  51 ---------------------------------------------------------
  52         1       3
  53         3       4
  54         5       2
  55
  56 echo SELECT f1,MIN(f3) FROM t1 GROUP BY f1 LIMIT 3 OFFSET 2;
  57 ---------------------------------------------------------
  58         f1      MIN(f3)
  59 ---------------------------------------------------------
  60         5       2009/8/3
  61         4       2009/8/2
  62         2       2009/8/3
  63
  64 echo SELECT f1,SUM(f4) FROM t1 GROUP BY f1 LIMIT 3 OFFSET 2;
  65 ---------------------------------------------------------
  66         f1      SUM(f4)
  67 ---------------------------------------------------------
  68         5       80
  69         4       100
  70         2       100
  71
  72 Statement Executed