1 CREATE TABLE emp10(eno int,ename char(10),job char(8),mgrno int);
2 INSERT INTO emp10 VALUES(1,'ALLEN','SALES',4);
3 INSERT INTO emp10 VALUES(2,'PITTER','IT',3);
4 INSERT INTO emp10 VALUES(3,'JACK','MKTING',1);
5 INSERT INTO emp10 VALUES(4,'TOM','CLERK',1);
6 INSERT INTO emp10 VALUES(5,'HARRY','MANAGERi',5);
8 echo SELECT emp.ename,mgr.ename FROM emp10 as emp,emp10 as mgr WHERE emp.mgrno=mgr.eno;
9 SELECT emp.ename,mgr.ename FROM emp10 as emp,emp10 as mgr WHERE emp.mgrno=mgr.eno;
10 echo SELECT emp.ename,mgr.ename FROM emp10 as emp,emp10 as mgr WHERE emp.mgrno=mgr.eno limit 3;
11 SELECT emp.ename,mgr.ename FROM emp10 as emp,emp10 as mgr WHERE emp.mgrno=mgr.eno limit 3;
12 echo SELECT emp.ename,mgr.ename FROM emp10 as emp,emp10 as mgr WHERE emp.mgrno=mgr.eno limit 2 offset 2;
13 SELECT emp.ename,mgr.ename FROM emp10 as emp,emp10 as mgr WHERE emp.mgrno=mgr.eno limit 2 offset 2;