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 ---------------------------------------------------------
11 emp.empid emp.ename emp.basic emp.join_date emp.mgrno emp.mgrname emp.allowances emp.mgr_date
12 ---------------------------------------------------------
13 7 SUMAN
7500.000000 2007/2/2 1:1:1.0 7 SUMAN
7500.000000 2007/2/2 1:1:1.0
14 1 JAMES
7000.000000 2007/2/2 1:1:1.0 3 PITER
8000.000000 2007/2/3 1:1:1.0
15 4 HARRY
8500.000000 2007/2/6 1:1:1.0 3 PITER
8000.000000 2007/2/3 1:1:1.0
16 2 LALIT
7500.000000 2007/2/1 1:1:1.0 1 JAMES
7000.000000 2007/2/2 1:1:1.0
17 3 PITER
8000.000000 2007/2/3 1:1:1.0 2 LALIT
7500.000000 2007/2/1 1:1:1.0
18 5 MAHES
6500.000000 2007/2/4 1:1:1.0 4 HARRY
8500.000000 2007/2/6 1:1:1.0
19 8 LATIF
7000.000000 2007/2/1 1:1:1.0 3 PITER
8000.000000 2007/2/3 1:1:1.0
20 6 RAMAN
6000.000000 2007/2/5 1:1:1.0 4 HARRY
8500.000000 2007/2/6 1:1:1.0
22 echo SELECT a.empid
, a.ename
, b.ename FROM emp as a
, emp as b WHERE a.empid
=b.mgrno
;
23 ---------------------------------------------------------
24 a.empid a.ename b.ename
25 ---------------------------------------------------------
35 echo SELECT a.empid
, a.ename
, b.ename FROM emp as a
, emp as b WHERE a.empid
=b.mgrno ORDER BY a.empid
;
36 ---------------------------------------------------------
37 a.empid a.ename b.ename
38 ---------------------------------------------------------
48 echo SELECT a.empid
, a.ename
, b.ename FROM emp as a
, emp as b WHERE a.empid
=b.mgrno ORDER BY a.empid
, b.ename DESC
;
49 ---------------------------------------------------------
50 a.empid a.ename b.ename
51 ---------------------------------------------------------
61 echo SELECT a.ename
, b.ename FROM emp as a
, emp as b WHERE a.ename
=b.mgrname
;
62 ---------------------------------------------------------
64 ---------------------------------------------------------
74 echo SELECT a.ename
, b.ename FROM emp as a
, emp as b WHERE a.ename
=b.mgrname ORDER BY a.ename
;
75 ---------------------------------------------------------
77 ---------------------------------------------------------
87 echo SELECT a.ename
, b.ename FROM emp as a
, emp as b WHERE a.ename
=b.mgrname ORDER BY a.ename
, b.empid DESC
;
88 ---------------------------------------------------------
90 ---------------------------------------------------------
100 echo SELECT a.ename
, b.ename
, a.basic FROM emp as a
, emp as b WHERE a.basic
=b.allowances
;
101 ---------------------------------------------------------
102 a.ename b.ename a.basic
103 ---------------------------------------------------------
104 SUMAN SUMAN
7500.000000
105 SUMAN PITER
7500.000000
106 JAMES LALIT
7000.000000
107 HARRY MAHES
8500.000000
108 HARRY RAMAN
8500.000000
109 LALIT SUMAN
7500.000000
110 LALIT PITER
7500.000000
111 PITER JAMES
8000.000000
112 PITER HARRY
8000.000000
113 PITER LATIF
8000.000000
114 LATIF LALIT
7000.000000
116 echo SELECT a.ename
, b.ename
, a.basic FROM emp as a
, emp as b WHERE a.basic
=b.allowances ORDER BY a.basic
;
117 ---------------------------------------------------------
118 a.ename b.ename a.basic
119 ---------------------------------------------------------
120 LATIF LALIT
7000.000000
121 JAMES LALIT
7000.000000
122 LALIT PITER
7500.000000
123 LALIT SUMAN
7500.000000
124 SUMAN PITER
7500.000000
125 SUMAN SUMAN
7500.000000
126 PITER LATIF
8000.000000
127 PITER HARRY
8000.000000
128 PITER JAMES
8000.000000
129 HARRY RAMAN
8500.000000
130 HARRY MAHES
8500.000000
132 echo SELECT a.ename
, b.ename
, a.basic FROM emp as a
, emp as b WHERE a.basic
=b.allowances ORDER BY a.basic DESC
, b.ename DESC
;
133 ---------------------------------------------------------
134 a.ename b.ename a.basic
135 ---------------------------------------------------------
136 HARRY RAMAN
8500.000000
137 HARRY MAHES
8500.000000
138 PITER LATIF
8000.000000
139 PITER JAMES
8000.000000
140 PITER HARRY
8000.000000
141 LALIT SUMAN
7500.000000
142 SUMAN SUMAN
7500.000000
143 LALIT PITER
7500.000000
144 SUMAN PITER
7500.000000
145 LATIF LALIT
7000.000000
146 JAMES LALIT
7000.000000
148 echo SELECT a.ename
, b.ename
, b.mgr_date FROM emp as a
, emp as b WHERE a.mgr_date
=b.join_date
;
149 ---------------------------------------------------------
150 a.ename b.ename b.mgr_date
151 ---------------------------------------------------------
152 SUMAN SUMAN
2007/2/2 1:1:1.0
153 SUMAN JAMES
2007/2/3 1:1:1.0
154 JAMES PITER
2007/2/1 1:1:1.0
155 HARRY PITER
2007/2/1 1:1:1.0
156 LALIT SUMAN
2007/2/2 1:1:1.0
157 LALIT JAMES
2007/2/3 1:1:1.0
158 PITER LALIT
2007/2/2 1:1:1.0
159 PITER LATIF
2007/2/3 1:1:1.0
160 MAHES HARRY
2007/2/3 1:1:1.0
161 LATIF PITER
2007/2/1 1:1:1.0
162 RAMAN HARRY
2007/2/3 1:1:1.0
164 echo SELECT a.ename
, b.ename
, a.mgr_date FROM emp as a
, emp as b WHERE a.mgr_date
=b.join_date ORDER BY a.mgr_date
;
165 ---------------------------------------------------------
166 a.ename b.ename a.mgr_date
167 ---------------------------------------------------------
168 PITER LATIF
2007/2/1 1:1:1.0
169 PITER LALIT
2007/2/1 1:1:1.0
170 LALIT JAMES
2007/2/2 1:1:1.0
171 LALIT SUMAN
2007/2/2 1:1:1.0
172 SUMAN JAMES
2007/2/2 1:1:1.0
173 SUMAN SUMAN
2007/2/2 1:1:1.0
174 LATIF PITER
2007/2/3 1:1:1.0
175 HARRY PITER
2007/2/3 1:1:1.0
176 JAMES PITER
2007/2/3 1:1:1.0
177 RAMAN HARRY
2007/2/6 1:1:1.0
178 MAHES HARRY
2007/2/6 1:1:1.0
180 echo SELECT a.ename
, b.ename
, a.join_date
, b.join_date
, a.basic
, b.basic
, a.empid
, b.empid FROM emp as a
, emp as b WHERE a.mgr_date
=b.join_date ORDER BY a.mgr_date DESC
;
181 ---------------------------------------------------------
182 a.ename b.ename a.join_date b.join_date a.basic b.basic a.empid b.empid
183 ---------------------------------------------------------
184 RAMAN HARRY
2007/2/5 1:1:1.0 2007/2/6 1:1:1.0 6000.000000 8500.000000 6 4
185 MAHES HARRY
2007/2/4 1:1:1.0 2007/2/6 1:1:1.0 6500.000000 8500.000000 5 4
186 LATIF PITER
2007/2/1 1:1:1.0 2007/2/3 1:1:1.0 7000.000000 8000.000000 8 3
187 HARRY PITER
2007/2/6 1:1:1.0 2007/2/3 1:1:1.0 8500.000000 8000.000000 4 3
188 JAMES PITER
2007/2/2 1:1:1.0 2007/2/3 1:1:1.0 7000.000000 8000.000000 1 3
189 LALIT JAMES
2007/2/1 1:1:1.0 2007/2/2 1:1:1.0 7500.000000 7000.000000 2 1
190 LALIT SUMAN
2007/2/1 1:1:1.0 2007/2/2 1:1:1.0 7500.000000 7500.000000 2 7
191 SUMAN JAMES
2007/2/2 1:1:1.0 2007/2/2 1:1:1.0 7500.000000 7000.000000 7 1
192 SUMAN SUMAN
2007/2/2 1:1:1.0 2007/2/2 1:1:1.0 7500.000000 7500.000000 7 7
193 PITER LATIF
2007/2/3 1:1:1.0 2007/2/1 1:1:1.0 8000.000000 7000.000000 3 8
194 PITER LALIT
2007/2/3 1:1:1.0 2007/2/1 1:1:1.0 8000.000000 7500.000000 3 2