test/sql/Limit/exp.test005.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 ---------------------------------------------------------
   8         emp10.eno       emp10.ename     emp10.job       emp10.mgrno
   9 ---------------------------------------------------------
  10         1       ALLEN   SALES   4
  11         2       PITTER  IT      3
  12         3       JACK    MKTING  1
  13         4       TOM     CLERK   1
  14         5       HARRY   MANAGER 5
  15
  16 echo SELECT emp.ename,mgr.ename FROM emp10 as emp,emp10 as mgr WHERE emp.mgrno=mgr.eno;
  17 ---------------------------------------------------------
  18         emp.ename       mgr.ename
  19 ---------------------------------------------------------
  20         ALLEN   TOM
  21         PITTER  JACK
  22         JACK    ALLEN
  23         TOM     ALLEN
  24         HARRY   HARRY
  25
  26 echo SELECT emp.ename,mgr.ename FROM emp10 as emp,emp10 as mgr WHERE emp.mgrno=mgr.eno limit 3;
  27 ---------------------------------------------------------
  28         emp.ename       mgr.ename
  29 ---------------------------------------------------------
  30         ALLEN   TOM
  31         PITTER  JACK
  32         JACK    ALLEN
  33
  34 echo SELECT emp.ename,mgr.ename FROM emp10 as emp,emp10 as mgr WHERE emp.mgrno=mgr.eno limit 2 offset 2;
  35 ---------------------------------------------------------
  36         emp.ename       mgr.ename
  37 ---------------------------------------------------------
  38         JACK    ALLEN
  39         TOM     ALLEN
  40
  41 Statement Executed