2 Statement Executed
: Rows Affected
= 1
3 Statement Executed
: Rows Affected
= 1
4 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 echo select * from emp
;
11 ---------------------------------------------------------
13 ---------------------------------------------------------
18 echo select * from dept
;
19 ---------------------------------------------------------
20 dept.deptno dept.dname
21 ---------------------------------------------------------
27 echo select * from emp
,dept
;
28 ---------------------------------------------------------
29 emp.eno emp.dno dept.deptno dept.dname
30 ---------------------------------------------------------
44 echo select * from emp
,dept where emp.dno
in(20,30);
45 ---------------------------------------------------------
46 emp.eno emp.dno dept.deptno dept.dname
47 ---------------------------------------------------------
53 echo select * from emp
,dept where dept.deptno
in(20,30);
54 ---------------------------------------------------------
55 emp.eno emp.dno dept.deptno dept.dname
56 ---------------------------------------------------------
64 echo select * from emp
,dept where emp.dno
in(20,30) and dept.deptno
in(20,30);
65 ---------------------------------------------------------
66 emp.eno emp.dno dept.deptno dept.dname
67 ---------------------------------------------------------
71 echo select * from emp
,dept where emp.dno
in(20,30) or dept.deptno
in(20,30);
72 ---------------------------------------------------------
73 emp.eno emp.dno dept.deptno dept.dname
74 ---------------------------------------------------------